Feedback by UserVoice

Anonymous

My feedback

  1. 378 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 feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    sum of sumif with {search1, search2} should be simplified, a solution using match and index seems simplest: matchif and indexif instead

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

    We’ll send you updates on this idea

    Many thanks Charles for analyzing and raising this issue! Also, many thanx to folks for voting as well. Please continue to vote for this issue if it’s important to you so we can prioritize it appropriately in the future.

    Thanx,
    Prash [MS Excel]

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    This issue was compounded by formulas switching to excel 2013 or later as the formulas must take care not to include the new limit of rows.

Feedback and Knowledge Base