Feedback by UserVoice

Anthony Newell

My feedback

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

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Anthony Newell supported this idea  · 
  2. 725 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]

    Anthony Newell commented  · 

    Sadly, I suggested it many years before that but it never got any traction. It's good to see MS more receptive these days. Remember, it's about trying to things slightly easier for the uninitiated. I'm sure you can pour cold water on my other suggestions so knock yourself out!

    Anthony Newell commented  · 

    Match & Index are so powerful in preference to using VLookup. In the same vain as the new 'IFS' function I think MS should release a new function called 'MINDEX' which wraps both functions together and makes it easier for the uninitiated. Basic users often find it hard to understand how to use Match & Index, even less so in combination

    Anthony Newell supported this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anthony Newell commented  · 

    I was thinking along these lines:
    You would select a cell at the top of a block of data whose size may change, say cell A1
    The wizard would anchor from A1 then automatically to produce the rest of the syntax for you, save you faffing about
    Obviously the wizard wouldn't work if you had no data below A1 but surely that would help with the fiddly setup
    It's another immensely powerful feature which is beyond most users

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

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Anthony Newell shared this idea  · 
  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anthony Newell shared this idea  · 
  6. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anthony Newell shared 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

    Anthony Newell shared this idea  · 

Feedback and Knowledge Base