Prev: Moving The Decimal Point Of Existing Entries
Next: Formula
From: HELPNEEDED!! on 3 Jul 2008 07:04
HELP!

I have a mind numbingly boring job of updating the prices in our work
spreadsheet.

Is there a way I can find a list of product codes in the new prices
spreadsheet and then automatically update the specific field in the product
database?
From: Pete_UK on 3 Jul 2008 07:51
It would help if you were to give more details of how your data is
laid out and what you want to achieve.

In the absence of that, I can only advise you to look in XL Help for
the VLOOKUP (and similar) function.

Hope this helps.

Pete

On Jul 3, 12:04 pm, HELPNEEDED!!
<HELPNEEDE...(a)discussions.microsoft.com> wrote:
> HELP!
>
> I have a mind numbingly boring job of updating the prices in our work
> spreadsheet.
>
> Is there a way I can find a list of product codes in the new prices
> spreadsheet and then automatically update the specific field in the product
> database?

From: "Bernie Deitrick" deitbe on 3 Jul 2008 08:17
Help,

In gerneral, use a formula like this in a new column next to your product database:

=IF(ISERROR(VLOOKUP(Code,NewPrices,2,False)),OldPrice,VLOOKUP(Code,NewPrices,2,False))

Where
Code is the cell in the same row with the product code
NewPrices is the table with the product code and prices - I've assumed a two column table. Use the
sheet name and absolute references
OldPrice is the cell in the same row with the old price

So, in a cell on row 2, it would look like

=IF(ISERROR(VLOOKUP(A2,NewPriceSheet!$A$1:$B$1000,2,False)),C2,VLOOKUP(A2,NewPriceSheet!$A$1:$B$1000,2,False))

Then copy that down to match your product database - copy it, and paste values over the old prices.

HTH,
Bernie
MS Excel MVP


"HELPNEEDED!!" <HELPNEEDED!!@discussions.microsoft.com> wrote in message
news:AAF97436-645F-4D38-A315-E9528587039D(a)microsoft.com...
> HELP!
>
> I have a mind numbingly boring job of updating the prices in our work
> spreadsheet.
>
> Is there a way I can find a list of product codes in the new prices
> spreadsheet and then automatically update the specific field in the product
> database?


 | 
Pages: 1
Prev: Moving The Decimal Point Of Existing Entries
Next: Formula