Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP and REPLACE
I have an aggregate spreadsheet, we'll call it Sheet 1. And then a sub-set
spreadsheet, we'll call it Sheet 2. Sheet 1 has ALL 14,900 rows. Sheet 2 contains 5,163 rows. The sub-set sheet, Sheet 2, contains information that needs to be overwritten in Sheet 1. The Sheet 2 sub-set has more recent information. Can anyone help me with a LOOKUP and REPLACE formula that will look for the key in Sheet 1 and Sheet 2 and replace the contents, just a couple of cells, in the appropriate cells in Sheet 1??? Thanks in advance. wnfisba |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP and REPLACE
You have two columns in sheet2 -- the key and the new info?
If yes, then I'd insert a new column in Sheet1. With the key in column A and the old info in column B and this in my new column C: =if(isnumber(match(a2,sheet2!a:a,0)),vlookup(a2,sh eet2!a:b,2,false),b2) If the keys match, use the info from sheet2, else use the info from column B. Then copy column C (Edit|Copy) select column B and edit|paste special|values and remove that new column C wnfisba wrote: I have an aggregate spreadsheet, we'll call it Sheet 1. And then a sub-set spreadsheet, we'll call it Sheet 2. Sheet 1 has ALL 14,900 rows. Sheet 2 contains 5,163 rows. The sub-set sheet, Sheet 2, contains information that needs to be overwritten in Sheet 1. The Sheet 2 sub-set has more recent information. Can anyone help me with a LOOKUP and REPLACE formula that will look for the key in Sheet 1 and Sheet 2 and replace the contents, just a couple of cells, in the appropriate cells in Sheet 1??? Thanks in advance. wnfisba -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing #N/A response when obtained in Lookup function | Excel Worksheet Functions | |||
How do I replace a return value of #N/A in a vlookup with zero? | Excel Worksheet Functions | |||
Find and replace with a lookup | Excel Worksheet Functions | |||
VBA Custom function for lookup | Excel Worksheet Functions | |||
lookup and replace data | Excel Worksheet Functions |