Thread: INDEX and MATCH
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PPL PPL is offline
external usenet poster
 
Posts: 18
Default INDEX and MATCH

Hi,
Excel 2003:
I have a column of figures in ascending order (can't be reveresed)

I'm trying to use INDEX and MATCH to find a value that is MORE THAN or equal
to a lookup_value. (and then to pick an adjacent cell value)


MATCH works great to recover the LESS THAN or equal value.

Is there another formula that I should be using?
TIA

Phil