Thread: vlookup with trim function
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
rodgie
 
Posts: n/a
Default vlookup with trim function

Thanks for the help. With your input ans some tweaking I have it
sorted.

Something alonf the lines of:

=IF(ISBLANK(E11),0,IF(COUNTIF(data!$A$4:$D$446,E11 ),INDEX(data!$A$2:$D$446,MATCH(E11,TRIM(data!$A$2: $A447),0),4),"check"))

but with the ctrl+shift+enter


--
rodgie
------------------------------------------------------------------------
rodgie's Profile: http://www.excelforum.com/member.php...o&userid=35090
View this thread: http://www.excelforum.com/showthread...hreadid=548513

Reply With QuoteReply With Quote