VLOOKUP Formula Question

[ajpowers]

I've got data from two different spreadsheets, but need the product cos
from Data Range A to put next to the sales price of Data Range B.

Data Range A
Model Number Product Cost
A 0.10
B 0.20
C 0.30

Data Range B
Model Number Size Sales Price
A 8x10 $1.00
B 5x7 $2.00
C 4x6 $3.00

What formula do I use if I want to get the SALES PRICE from Range B an
put it right next to the Product Cost

 

[mzehr]

Hi
Try using the following using your proper filename, cell
address, Rangename, etc

=VLOOKUP(A4,'C:\FOLDER\FILENAME2.XLS'!DATARANGEB,3,FALSE)

HTH

 

[ajpowers]

Thanks