Data from 2 Workbooks

[RChicken]

I've been handed a project where i need to find 750 part numbers and
replace their price with a new price.

How can i make it easier then useing the find option?

I'll try my best to give an example:

Workbook 1
| A | B |
Part# Price


Workbook 2
| B | C | D |
Part# Price Tax Price

 

[Guest]

Try VLOOKUP.
If the Price in Workbook1 is the new one, put in Workbook2 this finction
"=VLOOKUP($A$1;[Workbook1]Sheet1!A1:B10;2;0)" - this function search for
PartNumber in Workbook2 and place its Price to given cell (where is this
function).
I hope that this gives you an idea how to do it.

 

[RChicken]

as formuals go, i'm a beginner.

i've included these example files, which were pulled from the xls files
directly. to help give an idea.


+-------------------------------------------------------------------+
|Filename: excelfiles.ZIP |
|Download: http://www.excelforum.com/attachment.php?postid=4650 |
+-------------------------------------------------------------------+

 

[RChicken]

any ideas

 

[RChicken]

nevermind i got it

=VLOOKUP(AG11,[CARCONVMAP.xls]CARCONV!$A$2:$B$775,2,FALSE

 

[Guest]

Hi,
have you solved it? I'am not able to download samle files.