Vlookup

[maldonadocj]

Hello,

I need some assistance in creating a formula that removes spaces as a function within a vlookup formula. I am trying to write a vlookup formula that refers to a cell (A1) on Sheet1 to a range of columns on Sheet2. The problem is that the cells on Sheet 2 have a space in front of each entry so the vlookup formula does not "recognize" the data from cell A1. Is there a vlookup formula that can remove the spaces in front of the cell data on Sheet 2? Each cell data set contains 9 alpha or numeric digits.

Any assistance is greatly appreciated.

 

[njimack]

You'd be better off adding the space as part of the lookup formula...

=VLOOKUP(" "&A1,etc.)

 

[maldonadocj]

Hello njimack,

Thank you for the response. I got the #NAME error message when I utilized the formula you supplied. I also tried to utilize the ISERROR and ISNA function to overwrite the data, but this also didn't work. Any thoughts?

 

[njimack]

Can you post a sample of your data and the formulae you're using?

 

[maldonadocj]

Hello Neil,

I was able to locate the problem...Your formula worked fine after that..


Cheers..

Thanks again for the assist.

C.