software

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

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)quot;Carept Guyquot; gt; wrote in message
...
gt; i need to update my price book. i have my price list in 1sheet and
download
gt; my new pricing into another sheet. i need to look up the manuf name in my
gt; price book and return the new cost from the download sheet.. can any one
help
Also, make sure the a1 column in sheet2 is sorted alphabetically. This makes
a world of difference to that command.

Greg

quot;Bob Phillipsquot; gt; wrote in message
...
gt; Assuming that the downloaded list is structured name, cost, then you can
gt; use
gt; VLOOKUP
gt;
gt; =VLOOKUP(Sheet1!A1,Sheet2!A1:B1000,2,False)
gt;
gt; where A1 holds the name to lookup. Obviously, the A1:B1000 should adjust
gt; to
gt; whatever your limits are.
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;Carept Guyquot; gt; wrote in message
gt; ...
gt;gt; i need to update my price book. i have my price list in 1sheet and
gt; download
gt;gt; my new pricing into another sheet. i need to look up the manuf name in my
gt;gt; price book and return the new cost from the download sheet.. can any one
gt; help
gt;
gt;