LOOKUP Help!!!!

[Trademark]

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

 

[Roger Govier]

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

 

[BenjieLop]

Hi.

I'm having problems trying to lookup data in another worksheet. Thi
issue is that I have a databse with two columns of information in whic
the information needs to match in order to return the nmber shown in th
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 resul
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