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

ctrl+shift+enter (not just enter)



"Paige" wrote:

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)))