Using Vlookup inside Large function

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.

>Solution :

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)

Leave a Reply