Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup to pull data from another workbook
Wookbook 1 (Master.xls) & Workbook 2 (MSC.xls) have headers in row 1.
Wookbook 1 I need to use Vlookup using the Lookup Value (data starting in column B2). That value is then Looked up in the Table Array (A2:C500) located in Workbook 2. When a match is located from Workbook 2, the value in column C is then returned to Workbook 1 Column 20 Row 2. Example Workbook 1 If B22 contains WHAPPA Then in Workbook 2 WHAPPA is located the value in C Column is say Hello then Hello is the value placed in Worksheet 1 cell T22 Thanks. I hoope I am not making this difficult. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I pull sum from one workbook into another? | Excel Discussion (Misc queries) | |||
Can I pull in the filename used in Vlookup from another cell? | Excel Worksheet Functions | |||
VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
can vlookup pull from 2 columns into 1 column? | Excel Worksheet Functions | |||
Pull Data from a closed workbook, without opening it. | Excel Programming |