Vlookup & Find

  • Thread starter Thread starter Caroline
  • Start date Start date
C

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
 
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
 
Back
Top