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