Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match and extract
I have 2 files. Column A of File1 has a short list of words but with no
meaning next to them. Whereas, File2 the reference file, contains a long list of words together with their meanings in Column B. How can I match and extract the information from File2 to Column B in File1? For instance, it should not match "merge" with "emerge". Much appreciate your help. Regards, Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match and extract
Hi Tom,
VLOOKUP function. For the following example sssume that your File1 is Book1 and File2 is Book2. Formula placed in cell B2 in Book1. Copy formula down. =VLOOKUP(A2,[Book2]Sheet1!$A$2:$B$28,2,FALSE) Regards, Ossiemac "Tom" wrote: I have 2 files. Column A of File1 has a short list of words but with no meaning next to them. Whereas, File2 the reference file, contains a long list of words together with their meanings in Column B. How can I match and extract the information from File2 to Column B in File1? For instance, it should not match "merge" with "emerge". Much appreciate your help. Regards, Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match and extract
That was great. Thanks OssieMac.
"OssieMac" wrote in message ... Hi Tom, VLOOKUP function. For the following example sssume that your File1 is Book1 and File2 is Book2. Formula placed in cell B2 in Book1. Copy formula down. =VLOOKUP(A2,[Book2]Sheet1!$A$2:$B$28,2,FALSE) Regards, Ossiemac "Tom" wrote: I have 2 files. Column A of File1 has a short list of words but with no meaning next to them. Whereas, File2 the reference file, contains a long list of words together with their meanings in Column B. How can I match and extract the information from File2 to Column B in File1? For instance, it should not match "merge" with "emerge". Much appreciate your help. Regards, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and extract | Excel Worksheet Functions | |||
VLOOKUP or MATCH and/or INDEX to extract value on a given date | Excel Worksheet Functions | |||
Extract or report multiple arrays if a cell match a criteria | Excel Discussion (Misc queries) | |||
Compare and match names and extract a cell content | Excel Worksheet Functions | |||
formula to extract specific data if match occurs | Excel Worksheet Functions |