Vlookup beginning with 3, 4 or 5 specific values

[Guest]

I need to select values in the second column of a table based on the values
in the first column. Voolkup requires an exact match. My Lookup table is as
follows:

Lab1 35 (I need to match all records that begin with Lab1 and post the
value 35.

Thanks
Sam

 

[Bob Phillips]

=INDEX(K1:K13,MATCH(LEFT(G1,4),LEFT(J1:J13,4),0))

G1 is the value to check, J1:J13 is the lookup table key column, K1:K13 is
the lookup table results column.

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

=INDEX(B1:B13,MATCH("Lab1*",A1:A13,0))