|
|
#17
08-26-2021, 10:01 AM
|
||||
|
||||
In Sheet3 of the attached there's an additional table (green) based on the data in Sheet1 converted to a proper Excel table. All you need to do is update the table on Sheet1 ensuring all the data is in included in that table, then go to Sheet3, right-click the table and chose Refresh to update it. No formulas, no VBA.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
 Lookup
|
Tony Singh | Excel | 3 | 03-06-2015 11:03 AM |
| Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
|
Possible Lookup
|
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
|
LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
Windows 10 
Office 2019
Threaded Mode