Thread: Vlookup & Find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caroline
 
Posts: n/a
Default Vlookup & Find


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