Feedback by UserVoice

Chris Reichert

My feedback

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Chris Reichert commented  · 

    To add context, since Thomas K has completely misinterpreted what I've described.

    Attached file has two small datasets. The top dataset is just plain data. I use an XLOOKUP to find the pressure that corresponds to the temperature less than the input value provided. Works fine.

    The lower dataset is the same data, converted to a table. You can see that the headers have been converted from number to text (they are now left justified). Trying to run the same XLOOKUP function now returns an error. This is not optimal.

    Chris Reichert shared this idea  · 
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Chris Reichert shared this idea  · 
  3. 88 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Chris Reichert supported this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Graphics  ·  Flag idea as inappropriate…  ·  Admin →
    Chris Reichert shared this idea  · 
  5. 80 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, and thanks for showing how you’re using the FORECAST as a workaround. We’ll consider this request along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!

    Best,
    John [MS XL]

    An error occurred while saving the comment
    Chris Reichert commented  · 

    Maybe consider adding this as an option in the new XLOOKUP function, for a simple linear interpolation within the bounds of KnownXRange, it has the same inputs.

    Chris Reichert supported this idea  · 

Feedback and Knowledge Base