mercredi 25 février 2015

how to vlookup in excel if your table array with mixed data

I am trying to vlookup the values in Column C from Column A , the problem is the data I want to look for is mixed with text:


Screen Shot:


Sample Table layout


Aucun commentaire:

Enregistrer un commentaire