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. |
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 |