Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and Replace with value
BlankHi,
I have a huge report which has one of the columns containing a variable number of comma separated text (key of a record in database) -- like below. Sheet1 (Report) - Column A" ABC123,ABC456,ABC222 ABC234,ABC685 ............. ............. Each of the values above (ABC123 for example) is a key field for a record (database) and individual records are contained in another sheet - as below: Sheet2 (database) Column A: Column B Column C ABC123 field_1 ..... field2 ABC456 field_1 ..... field2 ABC222 field_1 ..... field2 What I need to do is to insert another column in Sheet1 (Report). This column should contain the respective field1 values (in the same order as keys themselves). What is the easiest/efficient way to accomplish this with formula and/or vba? Thanks for your help. Nadeem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace Lookup errors | Excel Discussion (Misc queries) | |||
Lookup and Replace | Excel Worksheet Functions | |||
LOOKUP and REPLACE | Excel Discussion (Misc queries) | |||
Find and replace with a lookup | Excel Worksheet Functions | |||
lookup and replace data | Excel Worksheet Functions |