VLOOOKUP Please help

[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

 

[Peo Sjoblom]

Your table is only 6 columns so you can't return a result from the 7th
column. If indeed you expanded the table with one more column you need to
change B3:G12 to B3:H12