|
|
#1
03-13-2023, 07:05 AM
|
|||
|
|||
Lookup different ranges based on chosen category.
hi team,
use an array formula to lookup a paritulcar range based on a category The following works but only because there is 1 range and 1 value i.e. in this case G10 is a date. =arrayformula(XLOOKUP(G10:G,RangeInfo!$E$16:RangeI nfo!$E$30,RangeInfo!$G$16:RangeInfo!$G$30,,-1)) the formula will go in C2 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to use lookup functions to calculate statistical paras using named ranges
|
Intruder | Excel | 8 | 05-09-2020 10:50 AM |
| Ranges that Grow Based on Data | TheThack | Excel | 1 | 07-27-2016 11:36 AM |
|
label merge category based...
|
versjan | Mail Merge | 4 | 07-15-2015 01:06 AM |
| Record Retention based off Category | jerelp | Outlook | 0 | 02-18-2010 08:06 AM |
| Archive rule based on Category | jerelp | Outlook | 0 | 02-18-2010 08:04 AM |
Windows 10 
Office 2021
Threaded Mode