Thread: EXCEL LOOKUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default EXCEL LOOKUP
Date in K1, duty in L1.

=INDEX('Sheet1'!$A$2:$A$173, MATCH($L$1, OFFSET('Sheet1'!$A$2:$A$173,
0, MATCH($K$1, 'Sheet1'!$B$2:$BA$2,0)),0)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote