Lookup/match value in a different worksheet, and just return a yes
 

I have two worksheets with lists of customers. I'd like to lookup each
company on worksheet A and see if it is also on Worksheet B. If it is, then I
just want an "X" or a 1 or a simple response like that. I couldn't seem to
make a VLOOKUP work or MATCH. Should I create a column with "X" in it on
Worksheet B and have that column returned as the value on Worksheet A?

Lookup/match value in a different worksheet, and just return a yes
 

=isnumber(match(a1,sheet2!a:a,0))

Will return TRUE if there's a match. False if there is no match.

Chatnoir11 wrote:

I have two worksheets with lists of customers. I'd like to lookup each
company on worksheet A and see if it is also on Worksheet B. If it is, then I
just want an "X" or a 1 or a simple response like that. I couldn't seem to
make a VLOOKUP work or MATCH. Should I create a column with "X" in it on
Worksheet B and have that column returned as the value on Worksheet A?

--

Dave Peterson

Lookup/match value in a different worksheet, and just return a yes
 

On Mon, 5 Jan 2009 15:08:07 -0800, Chatnoir11
wrote:

I have two worksheets with lists of customers. I'd like to lookup each
company on worksheet A and see if it is also on Worksheet B. If it is, then I
just want an "X" or a 1 or a simple response like that. I couldn't seem to
make a VLOOKUP work or MATCH. Should I create a column with "X" in it on
Worksheet B and have that column returned as the value on Worksheet A?


Assuming your lists of companies are on column A in sheet A and in
column A in sheet B you may try this formula in cell B1 of sheet A.

=IF(ISERROR(MATCH(A1,B!A$1:A$1000,0)),"","X")

Copy down as far as you have data in sheet A column A.
Change the 1000 if you have more data in sheet B column A.

Hope this helps / Lars-Åke

Lookup/match value in a different worksheet, and just return a
 

PERFECT! I have never heard of that command before, but it will get used a
lot now! Thanks!

"Dave Peterson" wrote:

=isnumber(match(a1,sheet2!a:a,0))

Will return TRUE if there's a match. False if there is no match.

Chatnoir11 wrote:

I have two worksheets with lists of customers. I'd like to lookup each
company on worksheet A and see if it is also on Worksheet B. If it is, then I
just want an "X" or a 1 or a simple response like that. I couldn't seem to
make a VLOOKUP work or MATCH. Should I create a column with "X" in it on
Worksheet B and have that column returned as the value on Worksheet A?

--

Dave Peterson

Lookup/match value in a different worksheet, and just return a yes
 

=IF(ISNA(MATCH(F11,Sheet2!D:D,0)),"","x")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chatnoir11" wrote in message
...
I have two worksheets with lists of customers. I'd like to lookup each
company on worksheet A and see if it is also on Worksheet B. If it is,
then I
just want an "X" or a 1 or a simple response like that. I couldn't seem to
make a VLOOKUP work or MATCH. Should I create a column with "X" in it on
Worksheet B and have that column returned as the value on Worksheet A?