EXCEL - Functions, Hlookup, Vlookup, Match & Offset

I have an excel spreadsheet.

Column A Row 1 - Label (PName/PManager)
Column A Row 2 - Project Name
Column A Row 3 - Project Manager
Column B Row 1 - Label (Project Number)
Column B Row 2 - Project Number
Column C Row 1 - Label (Month)
Column C Row 2 - Cost
Column C Row 3 - C, B, P, etc (C=Construction, B=Bid, P=Program, etc)

Before I start, I have attempted to move Column B, Row 2 down to equal row 3 but to no luck. There are over 2,000 rows so I cannot easily move data around.

What I am attempting to do is to extract the Project Number by what Phase (C, B, P, etc)

I have tried Vlookup, Hlookup, Match, Offset, and I cannot determine which function to use. Please help!



Below is an example of above mentioned setup.

A                    B     C     D
1. PName/PManager          P#     Dec     Jan
2. John Doe Building          111     $10000     $15000
3. J. Smith                    B     C
4. Blank
5. Jane Doe Building            222     $7500   $9000
6. J. Smith                             P       C
And the column goes on for several months and there are over 2000 rows.

Above is an example of one project and a possible situation is to extract the Project # from all projects with B in Dec.

The result I am looking for is Project # 111.

I tried V Lookup but it only returns data in the same row and to the right plus the project number is a row above what I want to extract (C, B, P, etc). I tried to nest an Offset function within Vlookup but to no luck.
I know there is a way to do it, just can't seem to get the functions to work correctly.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

See http://www.cpearson.com/excel/lookups.htm#LeftLookup

Eventual alternative: Data|Filter|Autofilter, details see help.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stellar site for this kind of stuff: http://www.cpearson.com/excel/topic.htm

See for example 'Lookup with multiple criteria'
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.