MAP function Example to Eliminate need to copy down

About this lesson

@redtailfanschool In this next example I show a real application in which I have used MAP with an ARRAY LITERAL in the header row along with an INDEX/MAP/INDIRECT function to eliminate the need to copy down a formula which was causing issues if the formulas were not copied down. Original formula to be copied down: =IFERROR(INDEX(INDIRECT(J1180 & "!$C$1:$E"),match(D1180,INDIRECT(J1180 & "!$E$1:$E"),0),1),) Single formula in the first row: ={"Not Approved"; MAP(J2:J,D2:D, LAMBDA(region,id, IFERROR(INDEX(INDIRECT(region & "!$C$1:$E"), MATCH(id, INDIRECT(region & "!$E$1:$E"), 0), 1), "")))}

Original Description