Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mapping Coded Users and Corresponding Coefficients
I hope someone can help me with this:
I have a list of TYPES of users, each with a unique ID code and three numbers associated with that ID code. I also have a list of unique users, each with one of the ID codes. Is there a way to match the correct three numbers to each user on my user spreadsheet, perhaps without complicated visual basic programming? I wrote a macro that will make this work, but I'm hoping to use a technique that is more friendly for my coworkers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mapping Coded Users and Corresponding Coefficients
If each user has a unique ID which is common to both sets of data,
then there are various ways of matching them up - MATCH, INDEX, VLOOKUP etc. You will need to give more details of what you want to do if you want more detailed help. Pete On Aug 14, 5:28 pm, Johnny1496 wrote: I hope someone can help me with this: I have a list of TYPES of users, each with a unique ID code and three numbers associated with that ID code. I also have a list of unique users, each with one of the ID codes. Is there a way to match the correct three numbers to each user on my user spreadsheet, perhaps without complicated visual basic programming? I wrote a macro that will make this work, but I'm hoping to use a technique that is more friendly for my coworkers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mapping Coded Users and Corresponding Coefficients
the Vlookup is working quite well,
thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mapping Coded Users and Corresponding Coefficients
You're welcome - glad it worked for you.
Pete On Aug 14, 9:40 pm, Johnny1496 wrote: the Vlookup is working quite well, thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coded Information | Excel Discussion (Misc queries) | |||
coefficients of polynomial | Excel Discussion (Misc queries) | |||
Trendline coefficients | Charts and Charting in Excel | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |