| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Check data on colum A and find match on colum b
I need excel to check two lists of id codes and show if a match exists my
spreadsheet looks similar to this... Colum A Colum B axc123564 jku7784554 wes879566 abc123456 abc123456 uujk44521154 I want excel to check if items on colum b appear on colum a and inform me if a match is found in colum c This is what I want it to look like axc123564 jku7784554 No Match wes879566 abc123456 Match abc123456 uujk44521154 No match My sheet contains over 2000 id's Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
Threaded Mode
