How to extend an if statement between 2 different Files

[nickg420]

I have 2 files with model numbers and one file has UPC numbers tied to
certain model numbers is there a way to write an if statement to extend
between boh and automatically paste the UPC number tied to the model
number in the other sspreadsheet file?

 

[Bob Phillips]

Nick,

You can use VLOOKUP across multiple workbooks. This would reside in Book1

=VLOOKUP(1,[Book2]Sheet1!$A$1:$B$3,2,FALSE)

where 1 is the key values in A1:B3, B being the UPC in your case.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

Take a look at vlookup, if the file with the tied UPC numbers is similar to

model1 UPC
model2 UPC

and so on,
and in the other file you have the model numbers only (starting in A2)
then you can use something like

=VLOOKUP(A2,'C:\Path\[filename.xls]Sheet2'!$A$2:$B$10,2,0)