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.

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.