Re: Vlookup errors

Hello my Excel friends.

Here we go another day.....without success!

1. I formated columns A and E as 'special - phone number'

2. I did a full copy of the worksheet and re-pasted as values

3. When I replicate(d) your formula(s) I receive a #N/A error output

Here is the other formula with the same result. I did received a '!' alerting me to an error in my formula.

Regarding the TRIM option

I was able to do this for column A, where the space was before the phone number. When I did this it removed the () from number as well. When I tried to TRIM the phone numbers in column E it didn't remove the (). I have tried to format both the same in order to align in each column.

1. I wish I could attach the file I am working with as you may be able to find errors I am not seeing in the formatting. 
2. I am doing something wrong and trying to find out what that is will cause me to throw my computer out of the window!