| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import some data
I have 2 excel documents.
In the both documentc I have a stock no, but in document no. 2 I MANY. How do I import a collum (price) from document 2 with only the stock no. in document 1 and place the price on the same row as the stock no. Please someone lead me in the right direction. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import some data
assume the list is in Sheet2 with stocknumbers in column A and price in
column B Assume the single stock number is in C5 of Sheet1. In D5 of sheet1 put in a formula like =Vlookup(C5,Sheet2!$A$1:$B$200,2,False) or if C5 could be blank =If(C5="","",Vlookup(C5,Sheet2!$A$1:$B$200,2,False )) -- Regards, Tom Ogilvy "Anders Winther" wrote in message ... I have 2 excel documents. In the both documentc I have a stock no, but in document no. 2 I MANY. How do I import a collum (price) from document 2 with only the stock no. in document 1 and place the price on the same row as the stock no. Please someone lead me in the right direction. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Import external data, data includes Excel function | Excel Worksheet Functions | |||
| Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
Linear Mode
