Data Headers:
Period ResoureName ProjectName ProjectID SubTeam Work ActualWork

I have used a pivot table to get the value needed for breaking down project
hours by Team. I need to perform a vlookup that looks for the ProjectName
and SubTeam text values and return ActualWork value.
HEADER VALUE
A1, Period A2, 12
B1, ResoureName B2, Bob Thomas
C1, ProjectName C2, Project X
D1, ProjectID D2, 11292005
E1, SubTeam E2, Network Support
F1, Work F2, 20
G1, ActualWork G2, 10

vlookup ("Network Support", A1:G2, 2, 1) returns 10 correct?

But I need to first find "Project X". How can I do this? I know it's simple
but I have been racking my brain for 3 hours looking at offset, match, index,
etc.

I need to perform a vlookup on ProjectName and SubTeam and return the value
of Actual Work. Work and Actual Work fall in period 12 (known date range)

Please advise. If this is not clear please let me know to describe things
better.

Thanks,
Al

Looking at a previous post the idea of creating another column and combining
C2&E2 is the approach I will use. This solves my problem
=C2&E2 (F2 Cell) then vlookup(F2,A1:F2,-1,0)
This works for me...

"Al" wrote:

Data Headers:
Period ResoureName ProjectName ProjectID SubTeam Work ActualWork

I have used a pivot table to get the value needed for breaking down project
hours by Team. I need to perform a vlookup that looks for the ProjectName
and SubTeam text values and return ActualWork value.
HEADER VALUE
A1, Period A2, 12
B1, ResoureName B2, Bob Thomas
C1, ProjectName C2, Project X
D1, ProjectID D2, 11292005
E1, SubTeam E2, Network Support
F1, Work F2, 20
G1, ActualWork G2, 10

vlookup ("Network Support", A1:G2, 2, 1) returns 10 correct?

But I need to first find "Project X". How can I do this? I know it's simple
but I have been racking my brain for 3 hours looking at offset, match, index,
etc.

I need to perform a vlookup on ProjectName and SubTeam and return the value
of Actual Work. Work and Actual Work fall in period 12 (known date range)

Please advise. If this is not clear please let me know to describe things
better.

Thanks,
Al