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

Thanks!

 

[My Aswer Is This]

I never like clicking on links.
Please explain in words in detail what your wanting.

 

[SkiliedSin]

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)

 

[SkiliedSin]

Bump

 

[My Aswer Is This]

I saw this posting several days ago.
I do not understand what you want.
You said:

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)​

Tell me what is split out
What is output
And in what two cells?

 

[SkiliedSin]

Sorry, I mean spit out

Like what result from inputting a formula.

The cells B2/B3 sorry for the confusion.

 

[My Aswer Is This]

Edit

<tbody>
</tbody>

<strike></strike>

 

[My Aswer Is This]

Still not able to help
I guess your looking for a Excel Formual

 

[SkiliedSin]

Yup, I am looking for a formula rather than a macro if possible.

Thank you anyways.

 

[SkiliedSin]

Bump