ExcelBanter - VLOOKUP Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP Function (https://www.excelbanter.com/excel-discussion-misc-queries/205387-vlookup-function.html)

ashoulds

VLOOKUP Function

is there a way to have a Vlookup function return the next largest value if an
exact match is not found? Currently, it will only return the greatest value
equal to or less than the value?

Sheeloo[_2_]

VLOOKUP Function

Can you give an example? To me 'next largest value' and 'greatest value equal
to or less than' mean the same.

There is no way to change the behaviour of VLOOKUP unless you write your own
verision in VBA...

"ashoulds" wrote:

is there a way to have a Vlookup function return the next largest value if an
exact match is not found? Currently, it will only return the greatest value
equal to or less than the value?

All times are GMT +1. The time now is 04:29 PM.