Lookup different ranges based on chosen category.

		Microsoft Office Forums > Microsoft Excel > Excel
Lookup different ranges based on chosen category.

FAQ

Thread Tools

Display Modes

03-13-2023, 07:05 AM

tom_mc1

Windows 10 Lookup different ranges based on chosen category.

Office 2021

Novice

Join Date: Mar 2023

Posts: 2

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 PM.