Forum Discussion
Solved
Vlookup and return first value in list that is NOT NULL
Hi everyone, I have an issue where my VLOOKUP alone does not work as it will always return the first entry in my table. In my case I have several entries for Account name and it picks up the firs...
As variant in U11 it could be
=IFERROR( INDEX($F$2:$I$2351, MATCH(1,INDEX(($A$2:$A$2351=$T11)*(INDEX($F$2:$I$2351,,MATCH(U$10,$F$1:$I$1,0))<>""),0),0), MATCH(U$10,$F$1:$I$1,0)), "")and drag it to the right
Converted to a table
= IFERROR(
LOOKUP( 2,
1 / (Table1[EC Account: Account Name]=acName) / (Table1[2020]="ACTIVE"),
Table1[2020] ),
"NULL" )