Match and Find NOT exact value

[Mehrich]

HI,
I'm tring to search a data range for a value. The issue is
that I'm not only looking for that exact value, I also
need a positive reply, if the value is slightly of.
Is there a way to search a data range for a value range??

Thanks all.
M

 

[Frank Kabel]

Hi
have a look at the MATCH function in the Excel help. If you sort your
looup range and use '1' as last parameter it will return the value that
is smaller or equal to your search value.