Forum Discussion
vitoaiaco
Jul 28, 2021Brass Contributor
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...
- 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
SergeiBaklan
Jul 28, 2021Diamond Contributor
Afraid XLOOKUP() doesn't work on Excel 2007.
mtarler
Jul 28, 2021Silver Contributor
yea, I notice right after I hit post