HELP with Looking Up 2 Condition

[mova]

I am having difficulty creating a function that will lookup 2 values and return another.

For example:
Apple Red Delicious 1
Macinotsh 2
Granny Smith 3

want to match with:
Apple, Macintosh and retun the value 2

I want to create a lookup funtion that looks up the first column, then the 2nd column and if both match then return the value in the 3rd column

Please help!

 

[barry houdini]

If you still get #N/A you possibly don't have exact matches, what sort of data do you have?

 

[mova]

i am doing this from 2 different worksheets and pulling data from a pivot table

for example,
apple mac 1
apple red d 2
apple granny 3
orange orange 3
grapefruit grape 4

that is the data one one page
the page where i want the formula is similar, but without the #
so the list will be
apple mac
apple re d
apple granny
orange orange
grapefruit grape

and i want it to pull the number from the other worksheet that matches both column A and B[/img][/code]

 

[Aladin Akyurek]

Aladin - I tried the formula, and it seems to work for my top entry but when i copy the formula down it is returning the same value. I am not sure why!

You should have a closer look at the exhibit, which is based on your initial post, and the formulas. If your layout is indeed like the one in your initial post, what I suggested would exactly meet your needs.