| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup function assistance
I have two worksheets. One contains a list of zip codes and other account information. The other contains a list of zip codes and an assigned sales group name associated with that zip code.
I need to add the assigned sales group name to the first list by zip code. As I am new to this can anyone help? Thanks jim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function assistance
=INDEX(Sheet2!GroupRange,MATCH(ZipCode,ZipCodeRang e,0))
erajim wrote: I have two worksheets. One contains a list of zip codes and other account information. The other contains a list of zip codes and an assigned sales group name associated with that zip code. I need to add the assigned sales group name to the first list by zip code. As I am new to this can anyone help? Thanks jim |
|
#3
|
|||
|
|||
|
Thank you I will try it Tuesday when I get back to work. Have a Happy Holiday!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Lookup Function help | Excel Discussion (Misc queries) | |||
| Lookup Function Problems | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Linear Mode
