Thread: Excel VLOOKUP - Return cells that are not blank from range of specified cells
View Single Post
 
Old 04-14-2022, 04:30 PM
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
Yes,
Code:
=IFERROR(LET(b,Form1!$A:$AK,a,INDEX(b,MATCH(A2,INDEX(b,0,1)),{11,14,15,16,17,18,19,20,34,35,36,37}),INDEX(FILTER(a,NOT(ISBLANK(a))),1)),"")
works here.
Reply With Quote