Thread: Lookup by multiple criteria?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muster muster is offline
external usenet poster
  
Posts: 25
Default Lookup by multiple criteria?
I have a table like the following and I need to look up the 3rd column
based on the first 2. Anybody has a simple solution? Thanks a lot!

A a 3
b 5
c 1
B b 2
c 4

Reply With QuoteReply With Quote