5 Replies Latest reply on Jun 27, 2018 7:48 AM by Donald Olsen

    How to build a Hlookup style calculation

    Donald Olsen


      How would I recreate an excel style Hlookup type calculation on my table?

      In my mock up below I want to use the column "First OFS Year (float)" to drive the hlookup for the column that has the same "Full Date" then give me the value of that intersect.

      So because the row ""First OFS Year (float)" = 2023

      I want the value in the column "Full Date" that intersects in this case '166'


      The Excel formula i'm trying to reproduce is this =IFERROR(HLOOKUP($E7,$F$2:$Y7,$AA7,0)