| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Vlookup to pull data from another workbook
vlookup is a very simple formula to use
click into cell "T2" and press your formula button then choose Vlookup and allow the formula function to aid through the setup Note: if you have a question on worksheet functions, please post it in the worksheet functions Forum "Bill" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Vlookup to pull data from another workbook
I am try to do this using VBA code. Can you help.
"ben" wrote: vlookup is a very simple formula to use click into cell "T2" and press your formula button then choose Vlookup and allow the formula function to aid through the setup Note: if you have a question on worksheet functions, please post it in the worksheet functions Forum "Bill" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Vlookup to pull data from another workbook
You have more replies at your original thread.
Bill wrote: 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. -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
