look up a list and return a value

C

Carept Guy

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
 
B

Bob Phillips

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 said:
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
Click to expand...
help
 
G

Greg

Also, make sure the a1 column in sheet2 is sorted alphabetically. This makes
a world of difference to that command.

Greg
 
Top