I have two columns which look like this:
A B
1 DA111 Sarah.a
2 DA444 John.b
I will write names to column C from different file.
I want cell C to find exact name match in column B and if matched enter it's code from column A.
So i wrote my formula like this =VLOOKUP(C1;A:B;1;FALSE)
It gives me error of course because of mixed letters/numers. How can i fix it?
Bookmarks