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 |
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 |