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...
Martin_Weiss But you did use semi-colons between the curly brackets. UncleGene used commas and that's why he got the #REF error.
Riny_van_Eekelen,
yes, you are right. I did not notice the difference because I work on a German version, where I have to use semi-colons anyway 😉😉