lookup table

[wbaid]

Hello,

I am trying to do a look up table or if you have another tip go ahead and give it to me.

I have a table with number

121
253
215
95
125
12

I have range

0-100 --> A
101 - 200 --> B
201 - 300 --> C

What I want from on table next cell it should get the grade like
121 >> B
253 >> C
215 >> C
95 >> A
etc

I need to get those grades from the range. can you help with this please

 

[VoG]

Try like this

=LOOKUP(A1,{0,101,201},{"A","B","C"})

 

[wbaid]

You are Genius. Please explain to me how it works, step by step please.

 

[VoG]

It looks at the value in A1, compares to the list in the left hand {} and returns the corresponding value in the right hand {}.