VLookup

  • Thread starter Thread starter Raphael
  • Start date Start date
R

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
 
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)
 
Thanks Bob, You are a life saver

Bob Phillips said:
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)
Click to expand...
 
Back
Top