Try this:

=INDEX(B1:B4,MATCH(A10,LEFT(A1:A4,FIND("-",A1:A4)-1)+0,1))

ctrl+shift+enter, not just enter


"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