Forum Discussion
Solved
Populating cell with value in immediate criteria match
Dear all, I have attached a spreadsheet containing raw data set for a fuel control spreadsheet. We have 4 types of vehicles: - Trucks, we dispense the exact amount of fuel according to the dest...
vitoaiaco That formula breaks because you are trying to look up the 8th column in a range that contains only 5 columns (E through I).
I have tried the following formula in column M, but it doesn't seem to work:
=IF(OR(Q5="EARTHMOVING",Q5="BUSES"),(VLOOKUP(E5,E6:I$9999,8,FALSE)),L5-K5)
=IF(OR(Q5="EARTHMOVING",Q5="BUSES"),(VLOOKUP(E5,E6:I$9999,8,FALSE)),L5-K5)
vitoaiaco That formula breaks because you are trying to look up the 8th column in a range that contains only 5 columns (E through I).
- Thank you for the reply. I have expanded my lookup range from E:L. It appeared to popular the cell correctly, but if I change the volume value it doesn't automatically change the value in column M. Would you have any idea why this happens?
vitoaiaco Sorry, don't follow. Cell M9 will return 119.00 with the adjusted formula. This is the number found in L19 for vehivle number "LD 02". Correct? What volume (e.g. in which column/cell) doesn't change the value in M?