G
Guest
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.
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.