Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
May 25, 2021
Solved

Let function used with Index.

Hi,   I try to figurer out how to use the new LET function, in this example wich has the same INDEX function several times.    Is it possible, if yes, aht is the solution?    Example file is at...
excel
Formulas and Functions
JKPieterse's avatar
JKPieterse
Silver Contributor
May 25, 2021
You mean like this:
=LET(Found,INDEX(t_priser,,XMATCH(J11,t_priser[#Headers])),XLOOKUP(SMALL(Found,1),Found,Found))
  • mtarler's avatar
    mtarler
    Silver Contributor
    May 25, 2021
    JKPieterse, Can I ask what is the point of the second XLOOKUP in that equation is for?
    XLOOKUP(SMALL(Found,1),Found,Found)
    Doesn't that just find the smallest value then look it up in the same array and return that same value again? I guess I'm asking why SMALL(Found,1) wouldn't work.
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      May 25, 2021
      I honestly don't know, I simply converted the formula to leverage the LET function. I did wonder about that though.
    • Hogstad_Raadgivning's avatar
      Hogstad_Raadgivning
      Iron Contributor
      May 25, 2021
      Since I started. It was just to practice and learn mostly. Good observation, SMALL(found,1) will work perfect.
  • Hogstad_Raadgivning's avatar
    Hogstad_Raadgivning
    Iron Contributor
    May 25, 2021
    Surer did. Thank you, it worked perfect.

    I was a bit to fast with "best reponse" here. Sorry.

    Thank you.

    Best regards
    - Geir

Resources