Link to another sheet and conditionally output


I have one sheet that I am trying to link to and output data conditionally.

There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF".

Is there a function I can use to bring in this data?

See below for example:

Best Answer

  • aileenr
    Answer ✓

    I figured it out!

    I had to add a row with the LineItem to reference, and a Row Index so it could be pulled down for multiple rows.

    =IFERROR(INDEX(COLLECT({WPIDs}, {Dept}, "CF", {LineItem}, $[DND_1055]$1), [Row index]@row), "")