Forum Discussion
VLOOKUP with two variable columns
I noticed that in your Excel sheet {1.2} was entered as {1,2}. I work with german version of Excel and i have to enter {1.2} in order to make the formula work. Try to enter {1.2} as well. I hope it works. Otherwise you would have to check how data in curly brackets has to be entered in your version of excel.
I didn't understand that you want to copy formula down from cell U9 to U12.
=VLOOKUP(S9&T9,CHOOSE({1.2},$AE$11:$AE$22&$AF$11:$AF$22,$AG$11:$AG$22),2,FALSE)
Formula has to be adjusted and entered as matrix with ctrl+shift+enter and then it can be copied down.
I noticed that in your Excel sheet {1.2} was entered as {1,2}. I work with german version of Excel and i have to enter {1.2} in order to make the formula work. Try to enter {1.2} as well. I hope it works. Otherwise you would have to check how data in curly brackets has to be entered in your version of excel.
I didn't understand that you want to copy formula down from cell U9 to U12.
=VLOOKUP(S9&T9,CHOOSE({1.2},$AE$11:$AE$22&$AF$11:$AF$22,$AG$11:$AG$22),2,FALSE)
Formula has to be adjusted and entered as matrix with ctrl+shift+enter and then it can be copied down.
Thank you