Fill Cells with Value if number falls between a certain range

[SkiliedSin]

Hey guys,

I was wondering if you guys could help me with this!

For example if the number falls between 0-15, to fill the cells adjacent to it with 1 "Name" and 2 "Age" (so 3 cells total)
16-30, to fill the cells adjacent to it with 2 "Name" and 4 "Age" (so 6 cells total),
and so forth and so on up until 80-95?

Would this be possible?

 

[Special-K99]

Please specify clearly the cell references as the formula will be dependent on this.

"cells adjacent to it"

on the same row?
in the same column?

Provide some input and expected output

 

[SkiliedSin]

Hey, sorry about that

Yup, same row but two spaces to the right of

the cell with the number.

 

[Special-K99]

"Provide some input and expected output "

 

[SkiliedSin]

Sorry, not sure how to attach an image on here.

https://imgur.com/a/3eYs8DJ

But basically, from that image I want to fill the cell "#Num!" and the two cells to the right of it with the words "Name", "Age" and "Age" because 54 (40-55) falls into the range in which I need to fill three cells with those three values if that makes any sense.

But I need it to change if the range was higher/lower as well to fill the cells with more/less instances of the word "Name" and "Age.

 

[Special-K99]

VBA or formulas ?

 

[SkiliedSin]

Either or is fine, but I would prefer a formula if it were possible.

 

[Special-K99]

This sounds like a VBA solution would be best and Im not an expert.

 

[Rick Rothstein]

Sorry, not sure how to attach an image on here.

https://imgur.com/a/3eYs8DJ

But basically, from that image I want to fill the cell "#Num!" and the two cells to the right of it with the words "Name", "Age" and "Age" because 54 (40-55) falls into the range in which I need to fill three cells with those three values if that makes any sense.

But I need it to change if the range was higher/lower as well to fill the cells with more/less instances of the word "Name" and "Age.

I'm sorry, but that picture is of no help in understanding what you want. Show us a picture of numbers from, say, three of your ranges and show us exactly what should be in the cells next to them (don't show us blank and errors, show us what you want our code to put in those cells).

 

[SkiliedSin]

Hey, sorry for all the confusion.

https://imgur.com/a/sQ8ETbO

Here is what I want it to look like, thank you.