=IF(ISNA(vlookup('SHEET B'!A1:B20,A2,2,False)),@@,vlookup('SHEET
B'!A1:B20,A2,2,False))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sonny" wrote in message
...
Hi all,
how do I select price from sheet B where sheet A part no is equal to sheet
B
part no. E.g.
I have a list on worksheet A with no price.
SHEET A
PartNumber Description Price
0000001
0000002
0000003
0000004
0000005
0000006
0000007

I have a list on worksheet B with values for price, I need these prices
for
the same part no as on worksheet A to populate the price column on
worksheet
A.
SHEET B
PartNumber Price
0000001 1.50
0000002 0.80
0000003 0.30
0000004 2.50
0000005 6.00
0000006 3.80
0000007 1.20

I cannot simply sort and copy the price information, as there are many
inconsistencies between these two worksheet some of the part no's may be
there some may not, but for any that are there I need the price.

Regs,
Sonny.