| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
compare data in two lists to find matching entries
I have a spreadsheet with two colums. Each colum contains an identification
reference e.g. Colum A Colum B abc123456 nmg4568987 ahsj45236 abc123456 ikl7856489 jkh7854566589 I want excel to check if the items in colums b are also in colum a and insert either "Match found" or "No match found" in colum c. For example abc123456 nmg4568987 No match found ahsj45236 abc123456 Match found ikl7856489 jkh7854566589 No match found Please help. I've tried everything I could think of. Nothing seems to work. |
|
#2
|
|||
|
|||
|
Try this in C1, and copy down:
=IF(ISNA(MATCH(B1,$A$1:$A$100,0)),"No Match","Match Found") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Chris (new user)" <Chris(new wrote in message ... I have a spreadsheet with two colums. Each colum contains an identification reference e.g. Colum A Colum B abc123456 nmg4568987 ahsj45236 abc123456 ikl7856489 jkh7854566589 I want excel to check if the items in colums b are also in colum a and insert either "Match found" or "No match found" in colum c. For example abc123456 nmg4568987 No match found ahsj45236 abc123456 Match found ikl7856489 jkh7854566589 No match found Please help. I've tried everything I could think of. Nothing seems to work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last row with data in it | Excel Discussion (Misc queries) | |||
| Excel2000: Data Validation to restrict entries | Excel Discussion (Misc queries) | |||
| How can I compare two lists of data (channel lineups) - find what. | Excel Worksheet Functions | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Linear Mode
