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...

excel

Excel on Mac

Formulas and Functions

SergeiBaklan

May 19, 2020

JennyHoA20181

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

Excel issue - vlookup returning null.xlsx307 KB

Forum Discussion

Vlookup and return first value in list that is NOT NULL

Resources