Advice on formulas (I think Lookup Function)

Hello.

Please see spreadsheet attached.

I am looking to create a formula to go into column B of sheet 2. For instance, in Cell B1, it should return the value "Yes" if the value in the cell A1 (of sheet 2) is present in the whole range of cells of Column A of sheet 1 AND Column C of sheet 1.

If this condition is not met, Cell B1 should return the value "No".

Is this possible?

Many thanks in advance for any assistance offered.

Best regards,

Ian
(Karelia Suite)

Put this in B1:

=IF(AND(COUNTIF(Sheet1!A:A,A1),COUNTIF(Sheet1!C:C,A1)),"yes","no")

then copy down.

Hope this helps.

Pete

Many many thanks Pete, this is exactly what I need!