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.

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.