Data from 2 Workbooks

R

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
 
J

jirkalla

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.
 
R

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 |
+-------------------------------------------------------------------+
 
Top