=IF(ISNA(VLOOKUP(A1,Sheet1!A1:B100,2,FALSE),"",VLO OKUP(A1,Sheet1!A1:B100,2,F
ALSE))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa" wrote in message
...
I have a list of reference numbers in column A, and a list of prices in
column B (Sheet 1).
In a separate sheet (Sheet 2) I have ref numbers and their price next to
them (for different products).
Can I put a formula in Sheet 2 to automatically insert the price for the
refrence number (i.e. link Sheet 2 to sheet 1 without putting <=If
??=123456,
£2.50for each individual reference number!)