Thread: Lookup different ranges based on chosen category.
View Single Post
 
Old 03-13-2023, 07:05 AM
tom_mc1 tom_mc1 is offline Windows 10 Office 2021
Novice
  
Join Date: Mar 2023
Posts: 2
tom_mc1 is on a distinguished road
Default 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
Reply With Quote