View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Partial match of a text

Hi Ai,

Am Tue, 14 May 2013 13:45:00 +0100 schrieb aikhalif:

A B C
command command command
exc axisid excel
metrics myer prop sport metrics
myer plc sports metrics myer prop
axis pty excel axisid
pivot toblerone pivott table
toble pivott table toblerone
chair 6 chair 6 chair


try:
=INDEX($B$1:$B$10,MATCH(IF(ISNUMBER(FIND(" ",A2)),LEFT(A2,FIND(" ",A2)-1)&"*","*"&A2&"*"),$B$1:$B$10,0))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2