Matrix searching

**Lionzz** · 09-12-2007, 05:55 PM

Let's say I have the following matrix:

Start End Letter
1 5 a
6 9 b
10 19 c
20 24 d

how can I automatically show the letter that's between certain numbers?

For instance, I type in number 14... Since it's between 10 and 19, it should show the letter "C"!

THANX!

**VBA Noob** · 09-12-2007, 06:00 PM

Say you enter 14 in D1 enter the below formula in say E1

=LOOKUP(D1,{1,6,10,20},{"a","b","c","d"})

VBA Noob

**Lionzz** · 09-12-2007, 06:11 PM

Thanx for the quick answer.

However, in your example, I must type in the matrix, right? I can't simply select the cases and he'll do automatically even if I change the original matrix, right?

Thanx!