Forum Discussion

vitoaiaco's avatar
vitoaiaco
Brass Contributor
Jul 28, 2021
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's avatar
    Jul 28, 2021

    vitoaiaco sry but just notice you said Excel 2007 so use this:

    =VLOOKUP(B2,B3:C$99999,2,FALSE)

    it does result in #N/A when not found but that is appropriate is it is Not Available yet

Resources