Excel Vlookup not working

preview_player
Показать описание
This shows a way to clean data to make a lookup work.
Рекомендации по теме
Комментарии
Автор

This was a fantastic help in turning my frustration into success. Thank you!

dbpanitch
Автор

clean() - who knew! Problem stemmed from opening Text file probably with a different encoding, and using import wizard for me. Was thinking Excel was broken! Oddly it was saying lookup value equalled with formula cell1=cell2 etc.

jeremyflowers