vlookup

  • Thread starter Thread starter Marion
  • Start date Start date
M

Marion

I would like to use a vlookup function that if the exact
criteria is not met does not automatically go to the
lower value but looks at the next highest value. Will
this work in combination with an if function and if so
could someone please let me know what the formula would
be.

Any help gratefully received.

Marion
 
Hi Marion
if your data range is sorted ascending just use
=VLOOKUP(your_value,range,column_index,TRUE)
 
Thank you for this, but in my data this returns an N/A
value as the data although ascending is not consecutive;
ie 1,3,5. Do you have any further ideas?

Regards

Marion
 
Hi
please provide some example data and describe your expected result
based on this example data
 
Back
Top