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
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
- Thank you x 1 million! Super helpful!
JennyHoA20181 , you are welcome
