Link to home
Start Free TrialLog in
Avatar of deanlee17
deanlee17

asked on

Vlookup returning #N/A

Hi guys,

As the title says my vlookip (Column B) is returning #N/A. Any idea why? I tried stripping out unwanted carriage returns etc but still no job. Project attached.

Thanks,
Dean
Book1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Ken Butters
Ken Butters
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rastoi
rastoi
Flag of Slovakia image
the #N/A means that there is no exact match in the list what is true in your case.
the strings in D column are filled with empty spaces to 30 characters. Modify your customer name data by  TRIM()  or use spaces in A2
Avatar of deanlee17
deanlee17

ASKER

Thanks guys