Thread: Double VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CCrew2000 CCrew2000 is offline
external usenet poster
 
Posts: 10
Default Double VLOOKUP

I have a database that is pretty big. In a nutshell, the database looks like:

A B C
Apple Red 12
Apple Yellow 5
Apple Green 7
Pear Green 6
Pear Blue 2

I'd like the vlookup to pull the data located in the 3rd column, first by
Apple (column A) and then by color (column B). So if I'm looking for Red
apples, I'd get the answer of 12. If I was looking for Green pears, I'd get
6.