Formula to return data from furthest row right with in column that has specific text

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

Then:

Formula:

=LET(header,$E$1:$Z$1,range,$E3:$Z3,list,FILTER(range,(range<>"")*(header="Supplier A PN")),IFERROR(INDEX(list,MAX(COUNT(list),COUNTA(list))),""))

Formula:

=LET(header,$E$1:$Z$1,range,$E3:$Z3,list,FILTER(range,(range<>"")*(header="Supplier B PN")),IFERROR(INDEX(list,MAX(COUNT(list),COUNTA(list))),""))

Formula:

=LET(header,$E$1:$Z$1,range,$E3:$Z3,list,FILTER(range,(range<>"")*(header="Supplier B PN Rev")),IFERROR(INDEX(list,MAX(COUNT(list),COUNTA(list))),""))

If you changed your headers, you could use them instead of text values. Then you could have one formula throughout.

You can even do this, so you only have to change the Far Right column in one place:

Formula:

=LET(fr,xfd,header,$E$1:$FR$1,range,$E3:$FR3,list,FILTER(range,(range<>"")*(header="Supplier A PN")),IFERROR(INDEX(list,MAX(COUNT(list),COUNTA(list))),""))