Thread: Lookup, True, IF ?

Hi,
I have 2 worksheets. In Worksheet 1, are the cost centers for a specific department (1000+) in a column. (Ex. 12513, 12567, 14368, etc). In Worksheet 2, I have every employees' (30,000+) cost centers in a column. I have been trying to create a function that would return a value of TRUE or FALSE on Worksheet 2 . I need to match, if the employee's cost center is within the department, listed on Worksheet 1.

Any ideas,... I am about bald now.

Thanks.

Hi,

Following formula should do the job ...

=IF(COUNTIF(Sheet1!$A$1:$A$1000,Sheet2!A2)=0,FALSE,TRUE)

HTH
Carim

Thanks Carim, but I couldn't get it to work. It gave me all FALSE.
Any suggestions ?

=IF(COUNTIF(Sheet1!$A$1:$A$1000,Sheet2!M2)=0,FALSE,TRUE)

Sorry I did not mention the following ...

1.make sure the range in sheet 1 is correct
2.make sure M2 is the first cell you want to test in sheet 2
3.make sure your first formula is located in the same row ...i.e row 2

HTH
Carim