Thread: complex lookup
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default complex lookup
Hello Doug,

Array-enter
=INDEX(Q3:Z41,MATCH(TEXT(FLOOR(E8,0.1),"0.0"),TEXT (P3:P41,"0.0"),
0),MATCH(TEXT(MOD(E8,0.1),".00"),TEXT(Q2:Z2,".00") ,0))

Regards,
Bernd
Reply With QuoteReply With Quote