Hi.

I'm having problems trying to lookup data in another worksheet. This
issue is that I have a databse with two columns of information in which
the information needs to match in order to return the nmber shown in the
third column. Here's an example to clarify:

Col 1 Col 2 Col 3
Apples 21 A
Pears 11 D
Apples 2 T
Oranges 21 G
Pears 2 E

If my conditions are "Apples" and "21" how can I obtain the end result
of "A" in column 3??

Keith


--
Trademark
------------------------------------------------------------------------
Trademark's Profile: http://www.excelforum.com/member.php...o&userid=27790
View this thread: http://www.excelforum.com/showthread...hreadid=472971

Hi

Try entering in C1
=IF(AND(A1="Apples",B1=21),21,"")

This will leave the cell blank, if both conditions aren't met.
You could put Apples and 21 in other cells e.g. F1=Apples, G1=21
then the formula would be
=IF(AND(A1=F1,B1=G1),21,"")
changing the values in F1 and G1 would not require you to edit the formula.

Copy down the sheet as far as required.

Regards

Roger Govier



Trademark wrote:

Hi.

I'm having problems trying to lookup data in another worksheet. This
issue is that I have a databse with two columns of information in which
the information needs to match in order to return the nmber shown in the
third column. Here's an example to clarify:

Col 1 Col 2 Col 3
Apples 21 A
Pears 11 D
Apples 2 T
Oranges 21 G
Pears 2 E

If my conditions are "Apples" and "21" how can I obtain the end result
of "A" in column 3??

Keith

Trademark Wrote:
Hi.

I'm having problems trying to lookup data in another worksheet. This
issue is that I have a databse with two columns of information in which
the information needs to match in order to return the nmber shown in the
third column. Here's an example to clarify:

Col 1 Col 2 Col 3
Apples 21 A
Pears 11 D
Apples 2 T
Oranges 21 G
Pears 2 E

If my conditions are "Apples" and "21" how can I obtain the end result
of "A" in column 3??

Keith

Try this array formula (commit with Shift-Ctrl-Enter keys):

=INDEX(C$1:C$5,MATCH(1,(A$1:A$5=\"APPLES\")*(B$1:B $5=2),0))



Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=472971