Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
I am building a spreadsheet to detail work assignments. Each person
could have a primary, secondary, and/or tertiary assignment. I want a summary sheet in the workbook which will pull in everyone assigned to a certain task. The problem I am having is I need a vlookup that will look in the primary column count 7 over, then look in the secondary column count 6 over, and finally look in the tertiary column and count 5 over (7, 6, and 5 represent the location of the column that will have each person's name). It would only find the value it was looking for in one of those columns. I am lost on how to accomplish this. All help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
Sounds like your "original design" is a bit off of achieving your need(s).
I'd consider setting up your table (like so - below) and using an Auto-Filter on any of the 3 columns. AssignmentName Individual Assignned InvRole Job 1 Peter P Job2 Bob P Job2 Teb A Job 1 Paul S Job2 Carol S Job2 Alice S Job 1 Mary A "japc90" wrote: I am building a spreadsheet to detail work assignments. Each person could have a primary, secondary, and/or tertiary assignment. I want a summary sheet in the workbook which will pull in everyone assigned to a certain task. The problem I am having is I need a vlookup that will look in the primary column count 7 over, then look in the secondary column count 6 over, and finally look in the tertiary column and count 5 over (7, 6, and 5 represent the location of the column that will have each person's name). It would only find the value it was looking for in one of those columns. I am lost on how to accomplish this. All help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |