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.
