The answer I supplied in an earlier thread also applies to this issue, but with a slight modification.
Do not take this the wrong way, but when you find something that works for you in a help forum, it would behoove you to review the solution in detail so that you understand how it works. Once you have a deeper understanding of the solution, you can use/modify the concept in other situations.
In the previous case, you wanted to return a value if a cell was not equal to 0, so you used the IF function to check for a 0:
In this case, you want the CHOOSE function to return a value if H10 is not empty, so the first thing you would do is check H10 to make sure it is not empty. The CHOOSE function then becomes the value_if_true argument for the IF function.
In this case the IF will return "" (nothing) if H10 is empty, but you could have it return whatever you want:
=IF(H10<>"",CHOOSE(H10,$I$2,$J$2,$K$2,$L$2,$M$2,""),"Please enter a value in H10")
2 additional notes:
1 - I'm not sure why you have "" as the last value for the CHOOSE function. If that was your attempt to deal with H10 = "", as you can see that won't work. Your CHOOSE function will return "" if H10 = 6 since that is the 6th argument in your list.
2 - You will note that I removed the parenthesis around H10 in the CHOOSE function. The first argument in the CHOOSE function is the index_num and there is no need to enclose it in parenthesis.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.