Heavy onions

[Guest]

Dear MrExcel,
This is the situation:
Three columns- A, B, and C

A B C
p 1 potato
q 1 tomato
r 1 ketchup
p 2 cheese
q 2 onions
r 2 garlic
p 3 peper
q 3 salt
r 3 eggs
. . .
. . .
. . .

How to select the item from the column C
that has the same row number as the value q in the column A and as the value 2 in the column B? (that is onions here)

Thanks,
KHE/E

 

[Tom Urtis]

Wouldn't an AutoFilter do what you want? Just choose your column A criteria (q) and column B criteria (2) and since this is an "And" situation, the value which would pass that And criteria combination is Onions.

Any good?

Tom Urtis

 

[Guest]

No, Tom, please read:
Does Excel support onions?

KNELE