Returning a Value based on Two conditions

[Djmason2001]

Good Morning Forum,

Aim : Based on two conditions “Group id(Column B)” and where “Helper (Column C) = 'Master'” I would like to return a value id(Column A) in Column D.


ID : Unique Id
Group Id : is a grouping mechanism to identify that two records should be considered for comparison
Helper : Is a indicator column to determine which id should be returned from Column A based on the GroupId.

I have attached scenarios below

ID	Group ID	Helper	Outcome
1234	21	Master	1234
2222	21	Non Master	1234
3333	25	Non Master	4444
4444	25	Master	4444

Looking forward to your response

 

[etaf]

you have also posted here

Returning a Value based on Two conditions

Good Morning Forum, Aim : Based on two conditions Group id(Column B) and where Helper (Column C) = 'Master' I would like to return a value id(Column A) in Column D. ID : Unique Id Group Id : is a grouping mechanism to identify that two records should be considered for comparison Helper...

www.excelforum.com

 

[Djmason2001]

@etaf - I have indeed. However in the other the other forum i have another outstanding question. Which is in more depth. I am trying to break the scenario down into multiple steps. and then piece it together.

 

[etaf]

=INDEX($A:$A,MATCH(F2&"master",$B$1:$B$100&$C$1:$C$100,0))
use control + shift +enter for and array
F2 is the ID you want to lookup

you should really post if using other forums, just saves everyone a lot of wasted time, coming up with a solution only to find it solved elsewhere

 

[Peter_SSs]

Welcome to the MrExcel board!

@etaf - I have indeed. However in the other the other forum i have another outstanding question. Which is in more depth. I am trying to break the scenario down into multiple steps. and then piece it together.

That's fair enough, but please read and follow our rule about what to do if you cross-post (post in more than one forum). See #13 of the Forum Rules

 

[Djmason2001]

Apologizes Etaf & Peter_SSs
The question i currently have outstanding another forum is this one "Building a URL which Dynamically passes attributes based on grouping criteria"
As mentioned above i may close this out and try and do each phase as a separate post.

@etaf
Thanks for giving me the example formula, the correct formula should be
=INDEX($A:$A,MATCH(B2&"master",$B$1:$B$100&$C$1:$C$100,0))