I am using a vlookup function with an array as the number I am searching for
is an a text range ("1-2","5-10","20-30") so Im taking the value of the cell
until the dash.

{=VLOOKUP(Q13,VALUE(LEFT(C20:I23,SEARCH("-",C20:I23,1)-1)),1)}

my problem is that it only allows me to offset the vllokup by 1. when I go
for more than 1 I get an error.
Any idea whats wrong with my syntax?
Thanks.

I'm not sure I understand, but how about:

=vlookup(q13&"-*",c20:i23,2,false)
to return the value in column D (the ,2, in that formula).

(maybe you don't want that false, too?)



ynissel wrote:

I am using a vlookup function with an array as the number I am searching for
is an a text range ("1-2","5-10","20-30") so Im taking the value of the cell
until the dash.

{=VLOOKUP(Q13,VALUE(LEFT(C20:I23,SEARCH("-",C20:I23,1)-1)),1)}

my problem is that it only allows me to offset the vllokup by 1. when I go
for more than 1 I get an error.
Any idea whats wrong with my syntax?
Thanks.

--

Dave Peterson