Hi John,
if the formula doesn't find the abbreviation will give a #N/A error, maybe
you have blank spaces somewhere in the abreviation, use trim option in
another column

=trim(A1)

then overwritte your column A with this information pasting it as values, do
the same in both sheets

"John" wrote:

In my workbook - on sheet1 the abbrev names are in col f - sheet2 has both
full and abbrev names in cols A & B respectively. So I modified your formula
below to and entered it in col G But I get #N/A in col G where I'm trying to
list full names.

Modified formula
=index(sheet2!$A$1:$A$10000,match(f1,$B$1:$B$10000 ,0))

Orig formula
=index(sheet2!$A$1:$A$10000,match(a1,$B$1:$B$10000 ,0))

I'm obviously missing something - formulas don't come easy to me.
--
John


"Eduardo" wrote:

Hi,
Let's assume you have a list of full names in sheet2 in column A and the
abbreviate name in column B, then in sheet 1 you have the abbreviate names in
column A, so in column B enter

=index(sheet2!$A$1:$A$10000,match(a1,$B$1:$B$10000 ,0))

"John" wrote:

I'll try this again as I accidentally hit the enter key after typing the
subject. In a spreadsheet I have all of my staff listed by their abbreviated
names used to identify them on our server. I want to be able to convert
there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the
If formualtions will work but I'm having difficulty. Can anyone please tell
me how to do this?
--
John