| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match, lookup or array?
i am currently working on a workbook that defines key responsiblities within
my business. it looks like the following: Worksheet 1 Worksheet 2 name team name/signiture for team A name1 A ____________ name2 B ____________ name3 A ____________ name4 A name/signiture for team B name5 B ____________ name6 B ____________ ____________ what i want to accomplish is when a particular person is designated as either A or B, their name is fill in under the appropriate column in the next worksheet, making it possible to print a hard copy of both. each blank space under "name/signiture for team $" on "Worksheet 2" is a seperate cell. i am not an expert by any means, and array's are an enigma to me, so any help would me very much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Match Index Lookup | Excel Discussion (Misc queries) | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Linear Mode
