Quote Originally Posted by TMS View Post
Corrects an error and makes the formula a little more resilient.

Formula: copy to clipboard 
=LET(Instructions, "Amend Workbook, Worksheet and Range, as required",  Mdata, [Example_Mastersheet.xlsx]Sheet1!$A$1:$D$1000,

 MA, INDEX(Mdata,SEQUENCE(ROWS(Mdata)),1),  MB, INDEX(Mdata,SEQUENCE(ROWS(Mdata)),2),

 COut, IF($F2<>"",FILTER(Mdata,MA=$F2,FILTER(Mdata,MB=$G2,"no match")),

       IF($G2<>"",FILTER(Mdata,MB=$G2,"no match"),"no match")),

 I_34,IFERROR(INDEX(COut,,{3,4}),""),I_3412,IFERROR(INDEX(COut,,{3,4,1,2}),""),I_34)
Thanks, TMS

It doesn't look like this formula is filling in the name columns, though it works well for filling out the other data. Is there a way to add this capability to the formula? I tried adding the formula to my datasheets, and it worked initially but is now just filling the blanks with "0"... I would appreciate a bit more explanation on the formula you created so I could understand it a bit better to adjust it to my uses as needed. I can see where to amend the workbook, worksheet, and range, but what part of the formula is specifying which cells of the mastersheet to autofill in the datasheet?

Take care,
Chrlyd