Forum Discussion
Is it possible to use HLOOKUP and CHOOSE to get my answers from different rows?
I have been meaning to ask if this formula works? AND if not what is the alternative if i stil wan to stick with using HLOOKUP? =HLOOKUP(D20,CHOOSE({1,2,3},Sales_Range,Disc,Disc_Level),2,TRU...
UncleGene Try it this way:
=HLOOKUP(D20,CHOOSE({1;2},Sales_Range,Disc_Level),2,TRUE)Use a semicolon in the "CHOOSE list" for a horizontal lookup, and a comma for a vertical lookup.