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)