What if it is NOT sorted in ascending order?
"Max" wrote:
Then, provided the list in col A is *sorted*
in ascending order, you could use
a "1" or "TRUE" in the 3rd arg in MATCH()
instead (or just omit the 3rd arg altogether)
=INDEX(A:A,MATCH(C1,A:A,1))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Roccobarocco" wrote in message
...
Ok, this works well if the exact value is in the range. What if the exact
value is not in the range and you need to return the first instance
closest
to your value?
|