Quote Originally Posted by TMS View Post
Just change the last entry from I_34 to I_3412
Formula: copy to clipboard 
=LET(Instructions, "Amend Workbook, Worksheet and Range, as required",  Mdata, 'C:\Test\[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_3412)
Thanks TMS,

I made that adjustment and it kind of worked, though the information was not in the correct columns. When I adjusted the formula to refer to my actual mastersheet, rather than the example sheet, it just had a lot of "0"s and "no match"s. I assume I must need to adjust the columns it's referring to within the mastersheet and where that info will be autopopulated within the datasheet, but I'm not sure what to edit.