If number is within range, fill cells next to it based on table

[SkiliedSin]

Hey,

I'm looking to see if it was possible to fill adjacent cells based on a number and it's status on a range.

So this is the table that I would like to use:

https://imgur.com/a/liFnrsa

I filled the a few out manually but I would like it to fill out like such:

https://imgur.com/a/PENpWrM

For those who don't want to click on links, here's a description of what I'm looking for.

Basically, I want to insert the cells next to the number with words depending on a table that I have in another sheet.

So I have number ranges, 1-15, 16-30 with different values like 1-15 would be the word "Age" while 16-30 would be the words "Age" "Age" etc etc

If A1 = 16, then I want B1 to split out the word "Age"
If A2 = 29, then I would want B2 to output "Age" Age" (in two cells)

Thanks!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...next-based-table-post5106513.html#post5106513

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.