number entered to reflect a job name/text
hey!
I was hoping to create a formula that gives me, in a column, a text that generates, from a number entered (146) based off of another sheet. i need to enter jobs done by each person via a number ID basically
Here is what I'm trying to do..
 Value equal to 1, when entered, would show "Head" and so on. there are 46 jobs.
I would like there to be multiple dropdowns. for example, if i have carl coleman, and he has a team job of 1 (head), i would like to simply type a 1, then have it show as a text of the job (head in this case) instead of a number. then i would like to be able to do it again in the same cell and have each job he has performed and so on. attached is the data. :)
Thank you ever so much for your help!
Answers

Hi @nctd ,
What you intend could be accomplished in different ways. I'm providing two possible solutions:
 You can add numeric values to each job in the dropdown list, this way you'd only need to type the number so that the complete value autofills:
 You may add an additional Helper Column to include each ID and create a crosssheet Formula in the target Column where the jobs need to be filled along the line of: =INDEX({Jobs}, MATCH(ID@row, {IDs}, 0)) This way, Jobs will be autopopulated by the formula each time that you add an ID number in the correspondent Column.
Note that you'll need to create a Column Formula for this to work as expected:
I hope that these ideas can be of help.
Cheers!
Julio
Help Article Resources
Categories
Check out the Formula Handbook template!