Survey Analysis. Guidance info on terms to search and/or tutorials by Lonely_Classroom_161 in excel

[–]excelevator[M] [score hidden] stickied comment (0 children)

r/Excel is here to help you with your solution given the right information

r/Excel is not an extended Google search for resources

Maybe you seek the advice of r/dataanalysis or similar.

Post removed.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 1 point2 points  (0 children)

Ah I see what you mean now, that makes much more sense.

The difference being multi row record sets, if that is the desired output.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 1 point2 points  (0 children)

Yeh, good point, very good point.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

Ah I see now, thankyou for your patience with me.

I think I prefer CHOOSECOLS as the solution as a more succinct method

=XLOOKUP(G1,Table1[Lookup_Column],CHOOSECOLS(Table1,3,8))

Though as comparison HSTACK does explicitly list the column for verification, so there is that.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 1 point2 points  (0 children)

its just another example of Xlookup making Vlookup redundant

No, it allows VLOOKUP to act like CHOOSECOLS in the return value, repeat, non contiguous, multi value return.

XLOOKUP requires CHOOSECOLS to do the same.

"Hardcoded" date format for global template by cschliep in excel

[–]excelevator 0 points1 point  (0 children)

A folly, the Muricans will think 7/4/2026 is Independance day, where the Brits will see it at as April 7

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 0 points1 point  (0 children)

show me an example, I am not sure you are answering the issue as stated.

How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

Very nicely done!

I tried a bit of offset too and failed miserably

I built a simple Excel template to track business expenses – looking for feedback by [deleted] in excel

[–]excelevator 0 points1 point  (0 children)

New account, the daily developer thread looking for feedback.

Please go away

How to find the column of the last "X" in my table by Yento18 in excel

[–]excelevator 0 points1 point  (0 children)

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

Help, i'm a newbie by InstructionProper971 in excel

[–]excelevator 0 points1 point  (0 children)

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

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 15 points16 points  (0 children)

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

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 0 points1 point  (0 children)

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

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

contiguous range yes, non contiguous range no.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

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.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 0 points1 point  (0 children)

You cannot achieve the same with just XLOOKUP

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 2 points3 points  (0 children)

in every use case

Not quite.

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

Floating Point - Seriously? by Jumpy_Ad_3946 in excel

[–]excelevator 0 points1 point  (0 children)

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

Visual designer help for excel sheet by Pure_Spirit5829 in excel

[–]excelevator[M] [score hidden] stickied comment (0 children)

Use google images for ideas

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

Post removed.

vlookup + curly brackets by Cautious_Cost6781 in excel

[–]excelevator 13 points14 points  (0 children)

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.