This seems so basic but I guess I"m too tired to even think tonight... Here is what I want to accomplish. I have two worksheets. I want to check if the value of cell A1 from worksheet 1 exists in column b from worksheet 2. If yes, then I want the value of B1 from worksheet 1 to be returned.

=IF(COUNTIF(Sheet2!A:A,A1)0,B1,"")

Change the "" at the end of the formula for whatever you want to show in the cell if the value in A1 is not found in column A of Sheet2. At the moment it will just leave the cell blank.

Hope that helps.

Hi,

Am Wed, 12 Sep 2012 02:35:18 +0000 schrieb Jenniferpod:

This seems so basic but I guess I"m too tired to even think tonight...
Here is what I want to accomplish. I have two worksheets. I want to
check if the value of cell A1 from worksheet 1 exists in column b from
worksheet 2. If yes, then I want the value of B1 from worksheet 1 to be
returned.

try:
=IF(COUNTIF(B:B,Sheet1!A1)0,Sheet1!B1,"")

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2