I really need help find this formula

February 9, 2018 at 07:36:12
Specs: Windows 7
How do I...I need help in the formula.

Really appreciate your help. I've attached an example (below) for what I'm looking for. I have unique IDs
for each project but there are multiple project managers attached to same IDs.

 ID               Project                 Project 
                             Manager 1           Manager 2
           B250         Chris                    Julia
           B291         Chris                    Alex
           C951         Fiona                   Julia

Project manager 1 is leading the project and project manager 2 is just assisting.
Now here what I want to do. I want to create a formula that when I choose project manager name lets say
"Chris" it should say "Lead" and when i choose project manager "Julia" it should say "Assist".

Keep that in mind that I am already pulling data from a source using the index and small function and its
working fine in getting all the other relevant information when i select the project manager example.

when I select Chris it gives me below details.

B250 ---   Project details -------    Budget   ---------   Hours    -----------     Lead

Here the problem is that same ID (B250) is using by another project manager with different hours and
working as an assistant so when I select Julia who is an assistant here what i get.


B250 ------------    Project details ---------------  Budget -------------  Hours -------------- Lead 
(This is the issue because she is not the lead and index function is pulling data from the same row in the dataset).

Hope I have explained it well.


See More: I really need help find this formula

Reply ↓  Report •
Related Solutions


Ask Question