@kyle381000
Firstly, thanks for posting anything that helps the Excel user community. However, while this illustrated how the CHOOSE function works, the example used was not appropriate. That is, it is not good practice to put location descriptions and agent phone numbers inside of the CHOOSE function as opposed to storing those values in one or more separate tables/arrays. Using such an example may give newbies the impression that this is a 'best practice' while it is not by any means. Perhaps a disclaimed would have helped to clarify that this was just for illustrative purposes and that there are better ways to address this particular problem.
@StopWhining491
But where do you store the location code? Otherwise, this doesn't look very helpful.
@ShivamKumar-pj3wt
majjhe kar diye tumne miyan
@MesameBendicta
Could you do a macro also VBA on Google drive Google sheets please I beg of you
@nheynazvic6563