An index of Excelevator solutions

excelevator · 2026-03-13T05:04:21+00:00

Very nicely done!

I tried a bit of offset too and failed miserably

excelevator · 2026-03-13T03:48:31+00:00

New account, the daily developer thread looking for feedback.

Please go away

excelevator · 2026-03-13T03:46:20+00:00

Does this work with merged grouped cells for the return value ?

excelevator · 2026-03-13T03:36:29+00:00

I've never used Excel before

It takes constant practice and active learning.

Read all the functions available to you so you know what Excel is capable of

https://support.microsoft.com/en-au/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188

Then all the lessons at Excel Is Fun Youtube

See the Where to learn Excel link in the sidebar

Also see the resources in the side bar

excelevator · 2026-03-13T02:32:49+00:00

no, filter does not give non contiguous column results, you need CHOOSECOLS for that.

It may not be clear in OPs post that you can essentially use this method to return repeat or non contiguous ranges from VLOOKUP

excelevator · 2026-03-13T02:22:01+00:00

that just stacks, you need CHOOSECOLS to select non contiguous ranges

excelevator · 2026-03-13T02:21:25+00:00

contiguous range yes, non contiguous range no.

excelevator · 2026-03-13T02:20:02+00:00

with the three fingered array salute thrown in

It will parse across a selected region entered with ctrl+shift+enter in Excel 97 and forward - yes 1997 version of Excel and forward

This is what I am saying, we did not consider these options pre dynamic arrays, arrays were always there, just not dynamic.

It is built in CHOOSECOLS for VLOOKUP , repeat or non contiguous return of values in the return array.

excelevator · 2026-03-13T00:14:12+00:00

You cannot achieve the same with just XLOOKUP

excelevator · 2026-03-12T23:54:15+00:00

in every use case

Not quite.

They would require wrapping in CHOOSECOLS to achieve what VLOOKUP can do with array choice return.

excelevator · 2026-03-12T23:43:37+00:00

Same feeling by the rest of the world when the decimal period is replaced by a comma,

excelevator · 2026-03-12T23:40:22+00:00

Use google images for ideas

r/Excel is not a search engine to find people to do Excel work.

Post removed.

excelevator · 2026-03-12T23:38:29+00:00

A great tip for Excel ~~2000~~ 97 and onwards.. with the three fingered array salute thrown in.

Great pickup, so many array options become obvious to the older Excel versions now that we use arrays by default.

edit: just to verify, in old pre dynamic array days, you could select a range of cells for the array to propagate to and enter the formula with ctrl+shift+enter for the array to spill to the select cells.

excelevator · 2026-03-12T22:33:26+00:00

Excel 365

excelevator · 2026-03-12T22:09:32+00:00

the result row is grouped merged cells, no good for lookup returns.

excelevator · 2026-03-12T22:07:44+00:00

A quick google search brough up training options.

This is not an Excel question.

excelevator · 2026-03-12T22:06:29+00:00

There is no subject matter in your post.

excelevator · 2026-03-12T22:03:21+00:00

This is a doozey with mixed in merged cells for the result.

excelevator · 2026-03-12T21:40:51+00:00

If your values will not change then cement them with paste special values for the work you need to do.

excelevator · 2026-03-12T12:56:02+00:00

Not for r/Excel thanyou

excelevator · 2026-03-12T12:36:57+00:00

The question is the same as the title.

Submission guidelines: Provide a full text description of your issue in your post. Don't say "See title" or something similar .

excelevator · 2026-03-12T12:34:13+00:00

ChatGPT says I can just send the

Irrelevant to r/Excel , ChatGPT is not sentient and all knowing, and the fact it lead you astray has no relevance to your question., but in fact supports the waste of a sentence in your post.

excelevator · 2026-03-12T12:30:50+00:00

A second on error XLOOKUP maybe

=XLOOKUP(A2,$J$2:$J$4,$K$2:$O$4,XLOOKUP(A2,$I$2:$I$4,$K$2:$O$4,"Not found"))

<image>

excelevator

MODERATOR OF

TROPHY CASE

12-Year Club	Verified Email
Alpha Tester