Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DOUBLE VLOOKUP | Excel Discussion (Misc queries) | |||
Double VLookup | Excel Discussion (Misc queries) | |||
Need Help with Double Vlookup | Excel Discussion (Misc queries) | |||
double vlookup in same function | Excel Worksheet Functions | |||
Vlookup - double criteria | Excel Worksheet Functions |