luckygoclimb
New Member
I'm probably wording the title wrong. I have two sheets. The first is a blank form for a character I want to create. On the left are the questions I want to answer for the character. For example, AGE. In the box to the right of that question, I want to be able to roll a dice physically on my desk and then type in the number to the box. Let's say #6 Then, I would like a formula to be able to go to the reference table on the second sheet and pull #6's corresponding word, in this case, rolling a 6 should return the answer (51-60) which automatically shows up in the box I typed 6 in. If it is an easier formula, I could just have it sent to the box to the right of the number rolled instead. So it would read AGE, 6, 51-60. If I were to type a 2 it would then show AGE, 2, 11-19. I have photos for what each page looks like. Top photo is first page, bottom photo is second page. I've colored in three sections to show where I want each information to go to. I'm not particularly saavy with Excel but I have to ability to google search if I don't understand an explanation. Most helpful would be to show me two or three of the same formula, cooresponding to two or three sections. The same formula used for AGE, and OCCUPATION for example. Thank you so much for any help given!!! I really appreciate it. I'm sorry if I overexplained the question. Better then under explaining it
Also, current version I am using is Google's Sheets on my account.
Also, current version I am using is Google's Sheets on my account.