| 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? |
| 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 | |||
Threaded Mode
