Vlookup & Find

[Caroline]

I need to use a VLOOKUP function but the "Lookup value" I am looking for
won't find an EXACT match in the "Table array".
Example :
- Lookup value = ABC
- Table Array contains = ABCD

I need to use VLOOKUP in order to return a value in another column of
the array, on the row corresponding to ABCD (... except if you have
another solution to propose !)

Thanks in advance

 

[Peo Sjoblom]

VLOOKUP accepts wildcards, e.g.

=VLOOKUP(A1&"*",B1:C10,2,0)

where A1 holds ABC

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Caroline]

Thanks Peo, it works perfectly !!