Replace a column of client code numbers with

Microsoft Office excel 2007 home & stude...
August 5, 2010 at 05:01:32
Specs: Windows 2007
Hi

I want to Replace a column of client code numbers in my time sheet with the client name for is in use.


See More: Replace a column of client code numbers with

Report •

#1
August 5, 2010 at 05:24:58
If you want to do it, go ahead and do it.

If you need help doing it, please ask.

DerbyDad03
Office Forum Moderator


Report •

#2
August 5, 2010 at 05:27:43
I need help on my question. some how the question was not completed and submited.

sorry guys please help me


Report •

#3
August 5, 2010 at 05:54:28
Since we can't see your spreadsheet from where we're sitting, we can only make assumptions and make suggestions based on that.

If your spreadsheet looks something like the table below, then VLOOKUP might work for you.

         A           B             C
1   Some Data   Emp Number A   More Data
2   Some Data   Emp Number B   More Data
3   Some Data   Emp Number C   More Data
4   Some Data   Emp Number B   More Data

Create a table with Client Numbers and their associated Names.:

         D          E                     
1   Emp Number A   Bob
2   Emp Number B   Steve
3   Emp Number C   Sue

Next in F1, enter this and drag it down:

=VLOOKUP(B1, $D$1:$E$3, 2, 0)

This will lookup the Emp Numbers from Column B and return the value (the name) from Column E.

(Review the Excel Help files for VLOOKUP to see how it works)

Once you have a list of Names in Column F for all the Emp Numbers in Column B, copy those names and do a Edit...PasteSpecial...Values over the Emp Numbers in Column B.

This will paste the values (the Names) not the formulas. It will also return a bunch of #N/A in Column F, but you shouldn't care because you don't need that list any more. Just delete anything you don't need.


Report •
Related Solutions


Ask Question