Mar 09 2022 10:41 AM
I need help I am new to excel and I am trying to create a spread sheet that total the amount of drywall sheets need for a job. I already created a vlookup list that is associated with each sheet of drywall in cell A1. which in another cell it automatically pops up the sqft of that particular sheet of drywall. which we will say it is in cell d1 now i have the total amount of sqft for the job in c1. Is there anyway I can add to the c1 formula in that same cell that would give me the total amount of boards needed for the job without adding another cell. thanks Fred
Mar 09 2022 12:43 PM
Mar 10 2022 05:20 AM
Mar 10 2022 09:30 AM
SolutionMar 10 2022 10:26 AM
Jan 12 2023 02:40 AM
According to me vlookup is an excellent tool in excel. It is very much useful when you have a big list of data and you want to pull the matching data with the values in one column
In simple terms
“VLOOKUP IS THE MAGNET TO PULL THE NEEDLE FROM THE HAYSTACK “
where the needle is the required data and the haystack is the master list of data.
An example, assume that you have a database of the list of employees working in the office ( say 10000 people ), and you have a list of 100 members who you want their Date of Birth and all the data is available in the master list.
Will you search for all 100 members one by one from the master list?
That's where vlookup kicks in if we insert the right formula the process will be done in a matter of minutes.
The formula goes like
{ =VLOOKUP( lookup value, array of content, column index number, condition) }
We can simply hold the cross-hair and pull for the rest of the rows required.
I personally use vlookup in almost daily to extract information from a pile of master data. It saves a ton of time by skipping the conventional method.
Best,
Zack Jerry
Essay Writer
Jan 12 2023 05:59 AM
Mar 10 2022 09:30 AM
Solution