Forum Discussion
Solved
max value if criteria match
Dear all, I hope you can help me with this. I am trying to generate a spreadsheet that can keep track of fuel consumption. The one responsible for this will enter the information related to mileage...
mtarler Could I please ask you for another favor?
I have attached the full data input sheet. Apart from tracking mileage, I'm looking also at regularly measuring any reserve left in the fuel tank. Each driver should keep 40 litres of fuel in the tank at all times and this is measured by dipping a level stick into the calibrated tank. Every time a truck goes out, the stick is dipped and we take a record of the level. Would be great if you could help me with a similar formula to match the fleet number with a previous trip and calculating the "float" variance for that particular trip.
The columns for float and any variance are H and I in the attached file...
Many Thanks
Vito
It sounds like you want the exact same thing but applied to columns H and I, so the same formula could be used but expand the table to include column H and change the 2 to a 5 (to indicate you want the 5th column returned instead of the 2nd):
=VLOOKUP(B2,B3:H$99999,5,FALSE)
=VLOOKUP(B2,B3:H$99999,5,FALSE)
- Yes, but this time I would like to calculate the + or - variance of the two readings. I've tried the following but it doesn't seem to work:
=VLOOKUP(D2,D3:H$99999,5,FALSE)-H5- It should work but your refs are a little scrambled (i just opened the sheet and saw some things shifted). Try:
=VLOOKUP(D5,D6:H$99999,5,FALSE)-H5