Say we have a list of names in column A from A1 thru A2000. The names all
appear in a much smaller list from C1 thru C50. In D1 thru D50 are the
equivalend numbers for each name.
In B1 enter:
=VLOOKUP(A1,$C$1:$D50,2,FALSE) and copy down thru B2000
Then copy column B and Paste/Special/Values onto column A.
Finally column B can be cleared.
--
Gary''s Student - gsnu200856
"Marcelo" wrote:
Gary, she is looking to replace each letter for a number, how vlookup will
look for each one?
thanks
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo
"Gary''s Student" escreveu:
If you have a translation table that gives a number for each name, then you
can use VLOOKUP().
See:
http://support.microsoft.com/default.aspx/kb/181213
--
Gary''s Student - gsnu200856
"Maria Teresa" wrote:
I have a big list of names that i need to replace for numbers .... is there
any way to do this in excel?
example:
Eduardo Gomez 3382736 46639 (according telephone buttons numbers)
Anny help.....very appreciated! Thanks for your time.
--
Teresa