LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
wnfisba
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing #N/A response when obtained in Lookup function CochranConsult Excel Worksheet Functions 4 June 26th 06 04:03 PM
How do I replace a return value of #N/A in a vlookup with zero? marketingman Excel Worksheet Functions 4 October 28th 05 09:45 PM
Find and replace with a lookup EMG03 Excel Worksheet Functions 4 October 21st 05 04:07 PM
VBA Custom function for lookup Sami82 Excel Worksheet Functions 9 September 12th 05 03:20 PM
lookup and replace data Xcellular Excel Worksheet Functions 1 April 18th 05 04:58 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"