Numbers to text

I wasn't entirely sure which forum to stick this one in, as I have no idea how to actually solve the issue.

A bit of a tricky one this one, at least for me, but I'm sure many fine individuals here can come up with an elegant solution.

A bit of context:
I'm making a character sheet for the RPG Alpha & Omega (if any of you've heard of it), as the regular one that is intended for the game is, well, rather bad. One of the things that I really like to do when I make character sheets, is that they update themselves automatically so that I don't have to go through the entire thing if I upgrade one of my attributes or skills. However, I've encountered the issue where I need to make excel convert a value into text, and not just converting a number into counting as text so it doesn't get involved into formulas and such. Read on for a further explanation.

Basically what I am trying to achieve is for excel to understand that whenever I type a value between 10-12, 13-14, 15-16 (and so on) for it to change that into a number of dice of a specific kind denoted as 1D6 as an example IN A DIFFERENT cell. If I write 14 in cell D11 for an example, it should put the dice "value" of 1D6 in the D14 cell. Once I get the method down I'll be able to type it out to work for all kinds and values of dice.

Is this even possible? Time to set it all up isn't an issue I guess, as in the long run it will save me a lot of time, and keep me from mistakes when playing.

Let me know if what I was trying to explain here didn't make any sense, I'll try to rephrase myself.

Any help would be greatly appreciated.

Alpha & Omega character sheet.xlsx

Let's see if that works.

I've manually entered the dice values so far, but I'd rather have it do it by itself as far as possible.

It's not finished yet, but the principle will be the same across all of it.

In essence, yes! Based off the total, rather than the characteristic value. 10-12 would yield a value of 6D4, 13-14 would give 1D6, 15-16 would give 2D6. But this is for me to edit it.

Could you explain to me how you managed to get it working?

Thanks. I'lll take a look at VLOOKUP formulas. Never used them before.

Yeah okay I clearly do not understand the vlookup function. I followed a youtube tutorial (https://www.youtube.com/watch?v=-WAEzokHSJM), but I only get a #REF error. Any idea why?

I attached my attempt.

Hmm

All right.

I got it working, partially. However, when I try replicate the function further down on the page, it gives e a #N/A error now. Which is strange, because the 1st one is working 100% perfectly now (thank you so much!). Can the table not be used several times over or something?