| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching data from table
Hi, This seems simple but I am not able to figure it out. I would appreciate
any help. Please see the example below. This is the data that I have: Col A Col B 29890 Price 20010102 48.625 20010103 47.875 20010104 47.875 20010105 48.6875 66157 Price 20010102 28.9375 20010103 30.8125 20010104 31.9375 20010105 30.6875 This is the array im trying to match to (It is on Sheet2): 29890 BP 47896 JPM 66157 USB 69032 MWD What I need is to copy BP beside 29890 and USB beside 66157 in the data without changing anything else in column B. This is a small example, my files contain about 40,000 rows of data that I need to match with their ID numbers. My data needs to look something like this. Col A Col B 29890 BP Price 20010102 48.625 20010103 47.875 20010104 47.875 20010105 48.6875 66157 USB Price 20010102 28.9375 20010103 30.8125 20010104 31.9375 20010105 30.6875 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help matching data from one table to another | Excel Worksheet Functions | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Pivot Table data not matching source | Excel Discussion (Misc queries) | |||
| Data "Point" in graph not matching table | Charts and Charting in Excel | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
