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