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