Vlookup formula - assistance needed

**abdumon7** · 01-23-2018, 06:46 AM

Trying to do Vlookup from a data base. but result is not matching due to different data format. please assist.

Sample data file attached

**Stormin'** · 01-23-2018, 06:52 AM

Long Name in the data tab has trailing spaces. Try the array formula:

Formula:

Please Login or Register  to view this content.

You have to press CTRL + SHIFT + ENTER to apply an array formula, successful if Excel automatically puts {curly braces} around the formula.

**LeoTaxi** · 01-23-2018, 06:57 AM

spaces in sheet Data causes this
run this to remove all spaces

Please Login or Register  to view this content.

Kind regards
Leo

**abdumon7** · 01-23-2018, 07:39 AM

Its working now. Thank you very much for your assistance.

Re: Vlookup formula - assistance needed