Thread: INDEX OR MATCH
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
  
Posts: 57
Default INDEX OR MATCH
Hello carl,

If your first table is in A1:C4 and you have a code to lookup in E2
and an ID in F2 try this formula in G2 copied down

=LOOKUP("zzzzz",CHOOSE({1,2},"",LOOKUP(2,1/(EXACT(E2,B$2:B$4)*EXACT
(F2,A$2:A$4)),C$2:C$4)))

Reply With QuoteReply With Quote