| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup a value in a table
sheet1:
Column A- List of 20 names Column B one of six offices listed next to each name Column C various assignments Sheet2: I want to show only those names that have "officeX" listed in column B, and their assignments in the adjacent cell. This information must be on a seperate sheet, organized by office. Any help would be appreciated! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lookup a value in a table
how about using data, filter and then copy to the other sheet -- duan ----------------------------------------------------------------------- duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162 View this thread: http://www.excelforum.com/showthread.php?threadid=31894 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup value on a table?? | Excel Discussion (Misc queries) | |||
| table lookup | Excel Worksheet Functions | |||
| Table Lookup | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
