Forum Discussion
Solved
Formula writing
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 d...
- Yes, just add it to the formula so the if it row 40 as in the example above just add the D40/
E = D40 / VLOOKUP(A21,Sheet2!A21:B22,2,False)
Unfortunately all the formatting was lost in your message so I'm confused about your VLOOKUP but assuming that it is returning the sqft of the selected board then this should work.
Goodmorning mtarler,
I will write out exactly what I have. Sheet 1
A B C D E
39 Type and size of drywall Length of Drywall Height of drywall SQFT of Area Board Quantity
40 4x8x1/2 10ft 10ft 100 sqft 32 sqft
41
A = Sheet2!A21:B22 B = Length of the wall C = height of wall D = B40*C40
E = VLOOKUP(A21,Sheet2!A21:B22,2,False) Which actually is the sqft of each board. What I would actually like it to be is when I select what board it is that it gives me the actual amount of boards needed for the job I do not want to have to make another cell just for that. So is there anyway I can add to the vlookup formula which associates the the board selection 4x8x1/2= 32 to take that number and divide the 32 into D=100sqft and get the board quantity in the E cell? Or do I have to add another cell and put the formula in D40/E40? I hope this makes sense.
Sheet 2 Table
A B C
19 Column 1 Column 2 Column 3
20 Size of Drywall Sqft of Board Price
21 4x8x1/2 32 $12.82
22 4x12x1/2 48 $19.24
I will write out exactly what I have. Sheet 1
A B C D E
39 Type and size of drywall Length of Drywall Height of drywall SQFT of Area Board Quantity
40 4x8x1/2 10ft 10ft 100 sqft 32 sqft
41
A = Sheet2!A21:B22 B = Length of the wall C = height of wall D = B40*C40
E = VLOOKUP(A21,Sheet2!A21:B22,2,False) Which actually is the sqft of each board. What I would actually like it to be is when I select what board it is that it gives me the actual amount of boards needed for the job I do not want to have to make another cell just for that. So is there anyway I can add to the vlookup formula which associates the the board selection 4x8x1/2= 32 to take that number and divide the 32 into D=100sqft and get the board quantity in the E cell? Or do I have to add another cell and put the formula in D40/E40? I hope this makes sense.
Sheet 2 Table
A B C
19 Column 1 Column 2 Column 3
20 Size of Drywall Sqft of Board Price
21 4x8x1/2 32 $12.82
22 4x12x1/2 48 $19.24
Yes, just add it to the formula so the if it row 40 as in the example above just add the D40/
E = D40 / VLOOKUP(A21,Sheet2!A21:B22,2,False)
Unfortunately all the formatting was lost in your message so I'm confused about your VLOOKUP but assuming that it is returning the sqft of the selected board then this should work.
E = D40 / VLOOKUP(A21,Sheet2!A21:B22,2,False)
Unfortunately all the formatting was lost in your message so I'm confused about your VLOOKUP but assuming that it is returning the sqft of the selected board then this should work.
- mtarler thank you very much that is what i needed it works perfectly. That was so easy Im shaking my head right now thank you again Fred_Y1972