Feedback by UserVoice

Excel Help

My feedback

  1. 730 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.

    Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.

    JoeMcD [MS XL]

    Excel Help commented  · 

    Once I learned INDEX/MATCH, I never looked back. As most people point out, it is powerful and gets the job done. However... beginners usually learn VLOOKUP/HLOOKUP first and when I try to convert er...I mean, teach them INDEX/MATCH, the experience is harrowing because the argument order is reversed and the argument terminology is different. I've literally seen a coworker post a sticky on their well with both formulas written out and arrows describing how the arguments relate to each other. That's the kind of end user we're talking about here, the kind that is less technologically inclined than all of us here on uservoice.

    If MSFT or the community believes that keeping VLOOKUP is important, at least consider standardizing the order and wording of the function with its more powerful cousin.

  2. 871 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Excel Help supported this idea  · 
  3. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    Kenneth, I understand the syntax perfectly. As I wrote in my description and showed in the screenshots, I did use @ in one of my trials and it made no difference (and you can try it yourself, too you know!) Regardless, a whole-column reference like Table[Column], when used in a 1:1 relationship between the tables and with formula autofill turned on, DOES WORK. However, it only works when the A1 notation is the exact same in both worksheets. My post is about this second caveat.

    The fact that it works only when the tables are aligned in physical space is the issue. Tables are supposed to be independent of their A1 notation and that is the strength and purpose of structured references. It's the result of an oversight; a bug in the program.

    User Voice is for feedback on the software, not for soliciting solutions. I didn't ask for a lengthy workaround via helper columns, I'm trying to make the issue visible to the Excel team with the help of the User Voice community.

    Excel Help shared this idea  · 
  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    Kenneth I bring it up because this, like so many other intuitive and time-saving features, is a native feature in Google sheets. I'm sure you've either seen in these forums or experienced yourself that Google is much more attentive to user input and more aware of how we use their products than MS is, and the fact that this autocomplete already existed there before I even knew I needed it is a testament to how many people would use it in Excel.

    Excel Help shared this idea  · 
  5. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    I'd love to use add-ins to solve numerous Excel shortcomings, Gareth, but our organization requires we use MS products out-of-the-box.

    Excel Help shared this idea  · 
  6. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    Overall, the coloring is very hard to follow. It's not in my wheelhouse to know what is easiest for the eyes/brain to decipher (leave it to the PhD's and graphic artists), I just know that for a lot of long formulas, the only way I can understand them is copy+pasting into notepad and separating out the elements with indentation.

  8. 62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  9. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    Love this suggestion. It's the reason I sometimes avoid IFERROR and construct my own error checking.

    Excel Help supported this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  11. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  12. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  13. 95 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    You’ve provided feedback on the Excel Shared Workbook experience and we would like to know more about how you’ve used this feature and the value it provides. By taking this survey, you can help the Excel team better understand how to prioritize our Collaboration Experiences moving forward.

    Your input is greatly appreciated.
    Thanks

    https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR3M53G0xM8tHle2rOax4MqNUQ0lOWlM2OFRTTkJNRTVGQU1ZV0hDMTZYSy4u

    Excel Help supported this idea  · 
  14. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  15. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  16. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  17. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  18. 47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
  19. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help commented  · 

    3. Add Shift+click functionality to the filter menu, for selecting large numbers of consecutive items, but still fewer than the total list.

    Excel Help supported this idea  · 
  20. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Excel Help supported this idea  · 
← Previous 1

Feedback and Knowledge Base