View Single Post
 
Old 04-14-2022, 03:07 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

If you've got the LET and FILTER functions available in your version of Excel you can try:
Code:
=IFERROR(LET(b,Form1!$A:$AK,a,INDEX(b,MATCH(A219,INDEX(b,0,1)),{11,14,15,16,17,18,19,20}),INDEX(FILTER(a,NOT(ISBLANK(a))),1)),"")
where the {11,14,15,16,17,18,19,20} is the column numbers of interest where you add the column numbers at will. If you're looking for the columns to be searched in a different order then change the order in the curly brackets.
Reply With Quote