Heavy onions

Mar 1st, 2002, 05:20 PM

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 · Mar 1st, 2002, 05:36 PM

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

Mar 1st, 2002, 06:22 PM

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

KNELE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 05:20 PM	#1
Guest Posts: n/a	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

Mar 1st, 2002, 05:36 PM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,382	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

Mar 1st, 2002, 06:22 PM	#3
Guest Posts: n/a	No, Tom, please read: Does Excel support onions? KNELE