WAAAYyyy too much work! :)

Try something like this:
Hdgs A B C
1 From Through MyValue
2 0 999 Unknown
3 1000 24999 1
4 25000 59999 2
5 60000 149999 3
6 150000 499999 4
7 500000 999999 Unknown

A10: 75000
A11: =VLOOKUP(A10,A2:C7,3,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ynissel" wrote:

Is there any way to to a vlookup in a table like this?
A B
1 10,000-24,999 1
2 25,000-59,999 2
3 60,000-149,999 3
4 150,000-500,000 4
.
.
10 75000

I want to look up the number in cell A10 in the list a1-a4 and return the b
column number. As you can see the problem is that a1-a4 is text - I was
trying to do something with the mid function starting at a search string
("-") with the whole thing in an array - but couldnt get anything to work.
Any ideas?
Thanks,
Yosef