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

What range / s ... what category / s ?

You have a misspelling :

RangeI nfo!

Cross posted at Lookup different ranges based on chosen category.
Please read A message to forum cross posters - Excelguru

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post