|I'm as confused as AlteK.|
You have a number in C1, your return value needs to "correspond" (?) with that number and you have names in B5:B10.
I'm not seeing the connection between C1 and the names, nor do I understand what you mean by "corresponds".
Perhaps an example of your data would help.
Please click on the following line and read the instructions found via that link before posting example data. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.