IF, THEN Forumula Help

For your first choice, you can use a VLOOKUP to accomplish this. In your desired output cell on Sheet1 place this formula:

=IF(ISERROR(VLOOKUP(A1,Sheet2!A1:B400,2,0)),"NOT FOUND",VLOOKUP(A1,Sheet2!A1:B400,2,0)) note: if A1 appears more than once in A1:A400 on Sheet2, the first occurance will be returned.

Second choice: In C1 on Sheet2 enter this formula:

=IF(A1=Sheet1!$A$1,1,"") and copy this formula down to C400. Any match in column A will return the '1' in col. C

HTH

Bruce