What formula should I use to change some initials into names? For example DS to become Dave Smith?
E Eán Sep 12, 2008 #1 What formula should I use to change some initials into names? For example DS to become Dave Smith?
S Stefi Sep 12, 2008 #3 If you have a table in sheet say Fullnames, e.g like this A B DS Dave Smith etc. then you can use =VLOOKUP("DS",Fullnames!A:B;2;False) to return "Dave Smith". Insted of "DS" you can use cell reference, e.g. C2 containing initials. Regards, Stefi „Eán†ezt Ãrta:
If you have a table in sheet say Fullnames, e.g like this A B DS Dave Smith etc. then you can use =VLOOKUP("DS",Fullnames!A:B;2;False) to return "Dave Smith". Insted of "DS" you can use cell reference, e.g. C2 containing initials. Regards, Stefi „Eán†ezt Ãrta:
