Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup formula to return all instances of match? | Excel Discussion (Misc queries) | |||
Lookup and match then return data from another sheet | Excel Worksheet Functions | |||
LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
can lookup return err if no match found | Excel Worksheet Functions | |||
Match text to another worksheet and return a certain value | Excel Worksheet Functions |