look up a list and return a value
 

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

look up a list and return a value
 

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

look up a list and return a value
 

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

Greg

"Bob Phillips" wrote in message
...
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