Finding the corresponding letter in between range

[managingcrap]

I have two columns (one is mean and the other is max) and the third column, I have the corresponding letter. I have in total 5 rows with mins and maxes and corresponding letters. I want a function that when i put for example #3 on cell D9, then my cell E9 will spit out the corresponding letter.

Please see the attachment.

[sktneer]

Try this in E9

Please Login or Register  to view this content.

[Glenn Kennedy]

Similar solution...

Sktneer is as quick as ever!!

[sktneer]

Similar solution...

Sktneer is as quick as ever!!

But your formula is much simpler and better than mine.

[Speshul]

Oooh! So that's when you should use TRUE for Range_lookup in a vlookup!


Interesting note, between both of your solutions, over-range choices return opposite results. 100 gives an E with the vlookup, and an A with the index/match.

[sktneer]

Interesting note, between both of your solutions, over-range choices return opposite results. 100 gives an E with the vlookup, and an A with the index/match.

I don't think that OP is considering that scenario. He said that he has only five rows with Min and Max and row 5 will always contain the max possible number i.e. upper limit.

[Tony Valko]

Try this...

Data Range

	C	D	E	F
1
2	1	5		A
3	6	8		B
4	9	11		C
5	12	15		D
6	16	20		E
7
8		13	D
9		3	A
10	------	------	------	------

This formula entered in E8 and copied down:

=LOOKUP(D8,C$2:F$6)

Any number >=16 will return E.