| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using vlookup to find exact match
Hi,
I have two spreadsheets with same field called IDs. I want to know whether the IDs in the ID column of the first sheet is in the ID column of the second. I want to create a new column on the first sheet to return Yes/No depending on the result. I think I could use vlookup formula but have no idea how. Can anyone help me? Thank you! -- Message posted via http://www.officekb.com |
| 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) | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
