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


--
Caroline
------------------------------------------------------------------------
Caroline's Profile: http://www.excelforum.com/member.php...o&userid=33270
View this thread: http://www.excelforum.com/showthread...hreadid=530914

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" wrote in
message ...

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


--
Caroline
------------------------------------------------------------------------
Caroline's Profile:
http://www.excelforum.com/member.php...o&userid=33270
View this thread: http://www.excelforum.com/showthread...hreadid=530914

Thanks Peo, it works perfectly !!!


--
Caroline
------------------------------------------------------------------------
Caroline's Profile: http://www.excelforum.com/member.php...o&userid=33270
View this thread: http://www.excelforum.com/showthread...hreadid=530914