Prev: LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THAT CO
Next: Column total is wrong
From: Kathie on 3 Feb 2010 12:26
I have data that I download into Excel and initials are used for different
people. I need to give those initials a number in excel for example MJ = 01,
HS = 02..etc. Thank you.
From: Bill Sharpe on 3 Feb 2010 12:34
On 2/3/2010 9:26 AM, Kathie wrote:
> I have data that I download into Excel and initials are used for different
> people. I need to give those initials a number in excel for example MJ = 01,
> HS = 02..etc. Thank you.

see VLOOKUP in Excel help.

Bill
From: Otto Moehrbach on 3 Feb 2010 13:09
Kathie
You have to be more specific. Where are the initials (column, row,
sheet)? Where do you want the numbers placed? HTH Otto

"Kathie" <Kathie(a)discussions.microsoft.com> wrote in message
news:229C8CB9-4D63-4892-ABED-C3DC0833DC92(a)microsoft.com...
> I have data that I download into Excel and initials are used for different
> people. I need to give those initials a number in excel for example MJ =
> 01,
> HS = 02..etc. Thank you.

 | 
Pages: 1
Prev: LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THAT CO
Next: Column total is wrong