vlookup

[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

 

[Frank Kabel]

Hi Marion
if your data range is sorted ascending just use
=VLOOKUP(your_value,range,column_index,TRUE)

 

[Marion]

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

 

[Frank Kabel]

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