Using Vlookup inside Large function-CodePudding

Is it possible to use more than one Vlookup function inside Large or Small functions? I get a formula error when I try to do this

=Large((Vlookup("xxx",Table1,2,0),Vlookup("yyy",Table1,2,0),Vlookup("zzz",Table1,2,0)),2)

Thank you.

CodePudding user response：

Another solution would be: =LARGE(VLOOKUP({"xxx","yyy","zzz"},Table1,2,0),2)

Older Excel versions require this to be entered with ctrl shift enter.

CodePudding user response：

use CHOOSE:

=Large(CHOOSE({1,2,3},Vlookup("xxx",Table1,2,0),Vlookup("yyy",Table1,2,0),Vlookup("zzz",Table1,2,0)),2)

Older versions may need to use Ctrl-Shift-Enter instead of Enter when confirming the edit.

Or if you have it HSTACK:

=Large(HSTACK(Vlookup("xxx",Table1,2,0),Vlookup("yyy",Table1,2,0),Vlookup("zzz",Table1,2,0)),2)