Need to add an Excel function that does the following:
I have a validation list in one cell that i can choose between several(about 12) text names.
each name needs to show up a prefixed number value in a different cell once it is clicked.
it supposed to be easy, but it just don't know the function for it.
this is a one-time job.
please bid if you are confident you can do this, great feedback in end of work.