TRIM FUNCTION TO BE ADDED

[Shabbo]

Dear Sir,

I wanted to add trim function for vehicle numbers but I am getting following error please refer attached excel sheet.

 

[Chihiro]

Don't use entire column range in your array formula. Formula will iterate through every cell in column and creates rather large overhead on resource.

If you need to, use dynamic named range to capture range.

Trim function should only have B:B range in it's argument. Rest should be outside.
I.E. IF(TRIM(LookupLists!$B$2:$B$641)=Sheet1!$E532,1)

 

[Shabbo]

Dear Sir,
not working.

 

[Chihiro]

So how did you apply the formula and how it's not working? Give us more detail.

Not sure exactly what you are after. But this returned results.
=INDEX(LookupLists!$C$2:$C$641,MATCH(1,IF(LookupLists!$A$2:$A$641=Sheet1!$C2,IF(TRIM(LookupLists!$B$2:$B$641)=Sheet1!$E2,1)),0))

Confirmed as array (CTRL + SHIFT + ENTER).

 

[Shabbo]

Dear Sir,
Can you please apply trim for Sheet1 Column D.

 

[Nebu]

May be this

=INDEX(LookupLists!$C:$C,MATCH(1,MMULT((A2=LookupLists!$A:$A)*(TRIM(D2)=LookupLists!$B:$B),1),0))

Thanks

 

[Shabbo]

Dear Sir,

I wanted to add trim function for vehicle numbers but I am getting following error please refer attached excel sheet.

No Its not working on both I wanted to apply trim on both sheet.

please check my file I am not getting result.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan