Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Add 3D variants of the INDEX and MATCH functions

And generally go through all functions and either extend them or make variants such that they work with 2D and 3D ranges better. E.g. why doesn't CONCATENATE do something useful with range arguments.

13 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Levi Bailey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • miko commented  ·   ·  Flag as inappropriate

    yup.

    index(sheet 1:sheet 2!A1,match(A1,sheet 3:sheet 4,0)) would be really handy!!!!

    and i'd agree that concatenate seems essentially pointless when "&" does the same job...
    I had assumed =concatenate(a1:a100) would be where it came in handy, but that doesn't work either!

  • Bill Bekenn commented  ·   ·  Flag as inappropriate

    Interesting idea, but not sure how that would work. Using ranges through the sheets dimension has never been very stable and they are tricky to implement and modify.

    I suggest the problem with CONCATENATE() and ranges should be posted separately, that would definitely be useful.

Feedback and Knowledge Base