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
JennyHoA20181 try attached file.
I have used intermediate steps, via 'Dummy' columns under column AA to AE
I have also updated formulas for U11:X11 (highlighted them in Yellow)