Assuming that the downloaded list is structured name, cost, then you can use
VLOOKUP

=VLOOKUP(Sheet1!A1,Sheet2!A1:B1000,2,False)

where A1 holds the name to lookup. Obviously, the A1:B1000 should adjust to
whatever your limits are.

--

HTH

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


"Carept Guy" wrote in message
...
i need to update my price book. i have my price list in 1sheet and
download
my new pricing into another sheet. i need to look up the manuf name in my
price book and return the new cost from the download sheet.. can any one
help