limit lookup search to left three places

R

roger

I need to do a look up based on the first three places in the reference cell

a1 is cda1428a I want the vlookup to return the data based on the cda only.

How do you do this?
 
R

RagDyeR

One way:

=VLOOKUP(LEFT(A1,3),B1:C25,2,0)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I need to do a look up based on the first three places in the reference cell

a1 is cda1428a I want the vlookup to return the data based on the cda only.

How do you do this?
 
Top