| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Match Columns
I've got two columns of about 1500 site IDs, one (Col A) with a corresponding state name (Col B), the other without (Col C). For the life of me I can't get Excel to match C to A and then put the state name in D. Thank so much!
Col A..................Col B......Col C siteID..................ST......... SITE_ID NCCA10-1001....... MA.........NCCA10-1412 NCCA10-1002....... NJ......... NCCA10-1413 NCCA10-1003....... VA......... NCCA10-1417 NCCA10-1004....... MA.........NCCA10-1419 NCCA10-1005....... NY......... NCCA10-1420 |
|
#2
|
|||
|
|||
Quote:
=VLOOKUP(C2,$A:$B,2,FALSE) - that spits out the state in D, where the formula was pasted |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
| Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
| Match 2 columns to 2 columns in different worksheets | Excel Discussion (Misc queries) | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Linear Mode
