**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I need column V to show a number determined by a number in column U being within a certain range from a range table i.e. if column U reads between 52 and 62 then column V should show 5 if column V changes to a number between 63 and 74 column U should change to show 6

Solved by K. L. in 8 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
29/04/2018 - 04:46

Hi

Excelchat Expert
29/04/2018 - 04:46

Welcome to Got it Pro

User
29/04/2018 - 04:46

Hi

Excelchat Expert
29/04/2018 - 04:46

Can you paste your sample data so that i can help you better

Excelchat Expert
29/04/2018 - 04:48

Please explain the conditions so that i can build the formula

Excelchat Expert
29/04/2018 - 04:48

There is no value in column U

Excelchat Expert
29/04/2018 - 04:48

Please tell where is the formula required and based on which cell

User
29/04/2018 - 04:48

if column P is between 0-15 column Q should read U

Excelchat Expert
29/04/2018 - 04:49

but U does not ahve any value

User
29/04/2018 - 04:49

I removed confidential information which has shifted the table to the left

User
29/04/2018 - 04:49

if P is between 15 and 24 Q should show F

User
29/04/2018 - 04:50

if P is between 25 and 32 Q should show E

Excelchat Expert
29/04/2018 - 04:51

=if(AND(P4>0,P4<=15),U4,if(AND(P4>15,P4<=24),F4,if(AND(P4>24,P4<=32),E4,"")))

Excelchat Expert
29/04/2018 - 04:51

this is the formula

Excelchat Expert
29/04/2018 - 04:51

have put in Q

Excelchat Expert
29/04/2018 - 04:51

Please see

User
29/04/2018 - 04:52

I mean the letter 'U'

Excelchat Expert
29/04/2018 - 04:52

if value maches nothing then i have left it blank value

Excelchat Expert
29/04/2018 - 04:53

Ok

Excelchat Expert
29/04/2018 - 04:53

Done

Excelchat Expert
29/04/2018 - 04:53

=if(AND(P4>0,P4<=15),"U",if(AND(P4>15,P4<=24),"F",if(AND(P4>24,P4<=32),"E","")))

Excelchat Expert
29/04/2018 - 04:53

This is the formula

Excelchat Expert
29/04/2018 - 04:53

try changing value in column P

Excelchat Expert
29/04/2018 - 04:53

And see

User
29/04/2018 - 04:54

Thank you

Excelchat Expert
29/04/2018 - 04:54

Let me know if this helps you buddy

User
29/04/2018 - 04:54

that works

Excelchat Expert
29/04/2018 - 04:54

Welcome

Excelchat Expert
29/04/2018 - 04:54

Please do give good rating and reviews

Excelchat Expert
29/04/2018 - 04:54

It really helps

User
29/04/2018 - 04:54

of course excellent service

Excelchat Expert
29/04/2018 - 04:54

Thanks

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*