Range criteria

[AS]

Hi Experts,

i wanted to Pick range from the excel and wanted values according to range. Can you please help me in that.

Expected Result

Price	Values
2000	1
72000	1.2
2000	1
3000	1.2
4000	1.2
2000	1

Thanks in advance

[Clifford_Coon]

Hi @AS ,

Check this thread: I think it's what you are looking for.

Join on ranges - Alteryx Community

[AS]

Thank you so much. That helps 😀

Cheers