Thread: Two Variable Lookup with approximate ranges
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Two Variable Lookup with approximate ranges
Correction. I left the 0 out of the 1st MATCH.

=INDEX(Sheet2!B2:E7,MATCH(C3,Sheet2!A2:A7,0),5-MATCH(C5,
{250000,200000,150000,100000},-1))

Ken Johnson
Reply With QuoteReply With Quote