Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding and replacing
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding and replacing
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!! 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding and replacing
Help,
In gerneral, use a formula like this in a new column next to your product database: =IF(ISERROR(VLOOKUP(Code,NewPrices,2,False)),OldPr ice,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!!" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding & Replacing a list of Data in Multiple Columns | Excel Worksheet Functions | |||
Finding and Replacing | Excel Discussion (Misc queries) | |||
Dynamic finding and replacing via functions | Excel Worksheet Functions | |||
Finding, Replacing and Cut & Paste | Excel Worksheet Functions | |||
Finding and Replacing a "?" | Excel Discussion (Misc queries) |