VLOOOKUP Please help

B

brian.baker13

Hi

I am using VLOOKUP to calculate costs of overfill using a table of
data


I forgot to add in another type of unit that I needed to calculate so
created a 7th element to the table.

to add this into my vlookup I put a + sign in my formula:


=-(D18-(VLOOKUP(C18,'Data Table'!B3:G12,5,0)))*(VLOOKUP(C18,'Data
Table'!B3:G12,3,0)*E18/1000)+(D18-(VLOOKUP(C18,'Data Table'!
B3:G12,5,0)))*(VLOOKUP(C18,'Data Table'!B3:G12,7,0)*F18/1000)

repeated the formula again and added the 7th item on the table.

This does not help.

Please help

Cheers
Brian
 
Top