Thread: Lookup/match value in a different worksheet, and just return a yes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chatnoir11 Chatnoir11 is offline
external usenet poster
  
Posts: 10
Default 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?
Reply With QuoteReply With Quote