Value from Range

[Forestq]

Hi,

I want to put different text name for value depend on to which ranges value belong. My ranges:

0 - 15: text name: "AAAA"
6-28: text name: "BBBBB"
more than >29 : "CCCCC"

I have below code, but I know that my condition are wrong:

looking_date = ws.Range("B2").Value

if looking_date < 15 then
 ws2.Range("C2").Value = "AAAA"
Else if looking_date < 28 then
 ws2.Range("C2").Value = "BBBB"
Else
 ws2.Range("C2").Value = "CCCC"

are you able to help?

 

[MarcelBeug]

Formula solution, in C2:

=LOOKUP(B2,{0,6,29},{"AAAA","BBBBB","CCCCC"})

 

[Forestq]

number 3: is below 6 and 29...so your answer is wrong

 

[Fishboy]

0 - 15: text name: "AAAA"
6-28: text name: "BBBBB"
more than >29 : "CCCCC"

Surely this can't be right. Any value between 6 and 15 falls into 2 categories, both AAAA and BBBBB

 

[MarcelBeug]

number 3: is below 6 and 29...so your answer is wrong

What's wrong with you?

 

[Forestq]

What's wrong with you?

as also Fishboy wrote, number like 2 or 3 belond to both ranges (0-15, 0-28....)

ex. number 4 is less then 6,5,7,10....28 so I had to somehow add between function

 

[MarcelBeug]

as also Fishboy wrote, number like 2 or 3 belond to both ranges (0-15, 0-28....)

Yes, I guess this would be better:

=LOOKUP(B2,{0,16,29},{"AAAA","BBBBB","CCCCC"})

According to your VBA code, the second range starts at 16, not at 6.
And the third range starts at 29, so >= 29, not > 29?

 

[Fishboy]

Don't you just need to add "betweens"

if looking_date <= 15 then
 ws2.Range("C2").Value = "AAAA"
Else if looking_date >= 16 And <= 28 then
 ws2.Range("C2").Value = "BBBB"
Else
 ws2.Range("C2").Value = "CCCC"

 

[Forestq]

thanks Fishboy!

 

[Fishboy]

Happy to help