Need Way To Pull Data From Different Column Based On Input

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: Need Way To Pull Data From Different Column Based On Input

Reply ↓  Report •

#1
March 4, 2018 at 03:26:42
I would look in to trying some alternative non-Microsoft office software.

Reply ↓  Report •

#2
March 4, 2018 at 08:18:48
When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "I Need Help With A Formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#3
March 5, 2018 at 08:17:07
Haven't we gone through this already?

You still haven't provided enough information for us to help you. At least in your other thread you provided the formula that you are using, but you didn't supply enough information related to your input layout for us to be able to help. In this case, you haven't even provided the formula nor your overall layout.

For this specific question (when i choose project manager "Julia" it should say "Assist") the answer is easy. Since you didn't supply Column letters or Row numbers I'll have to do it. Then based on my layout, I'll provide a way to return "Assist" when Julia is chosen based solely on the information provided in this thread since that is the only thing I have to work with.

    A         B           C                         D
1  ID      Project      Project                   Julia
2          Manager 1    Manager 2  =IF(ISNA(MATCH(D1,B3:B5,0)),"Assist","Lead")
3  B250     Chris        Julia
4  B291     Chris        Alex
5  C951     Fiona        Julia

Now, perhaps you can take that formula (or the concept behind that formula) and adapt it for your needs.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
March 5, 2018 at 12:08:34
Fooling around with this a little more, maybe something like this will get you where you want to go:

=INDIRECT(IF(ISNA(MATCH(D1,B3:B5,0)),"C","B")&2)

Using the example data layout in my previous response, this will return either Manager 1 or Manager 2 depending on the name in D1.

The point here is that you may be able to combine various functions to return specific data based on which column the value in D1 is found.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

Ask Question