VLookup

[Raphael]

Hi Everyone,
I am try to do a VLookup on 2 spreadsheet, using a product
number and price. if product number in spreadsheet A matches the product
number in Speadsheet B copy the price column in B to A.
Any ideas will really be appreciated.

Raphael

 

[Bob Phillips]

Raphael,

=VLOOKUP(Sheet1!A1,Sheet2!A1:B100,2,FALSE)

--

HTH

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

 

[Raphael]

Thanks Bob, You are a life saver

Raphael,

=VLOOKUP(Sheet1!A1,Sheet2!A1:B100,2,FALSE)

--

HTH

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