ExcelBanter - countif, isna, or vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif, isna, or vlookup (https://www.excelbanter.com/excel-worksheet-functions/447100-countif-isna-vlookup.html)

Jenniferpod

countif, isna, or vlookup

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.

Spencer101

Quote:

Originally Posted by Jenniferpod (Post 1605408)

=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.

Claus Busch

countif, isna, or vlookup

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

All times are GMT +1. The time now is 05:53 PM.