View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paige Paige is offline
external usenet poster
 
Posts: 270
Default Way to Incorporate Trim Into Match/Index Formula

I have the following formula and am trying to incorporate the trim function
into it; i.e., I want to match the trimmed E2 to the trimmed V:V. Is there a
way to modify the formula to do this; haven't been successful yet in figuring
this out. Just adding trim in (or clean) doesn't work, at least not how I've
tried it so far.

=IF(ISNA(MATCH(E2,V:V,0)),"",INDEX(AB:AB,MATCH(E2, V:V,0)))