Returning a Value based on Two conditions

Djmason2001

New Member
Joined
Feb 24, 2020
Messages
14
Office Version
  1. 2013
Platform
  1. Windows
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

IDGroup IDHelperOutcome
1234
21Master
1234
2222
21Non Master
1234
333325Non Master4444
4444
25
Master4444

Looking forward to your response
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
you have also posted here
 
Upvote 0
@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.
 
Upvote 0
=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
 
Upvote 0
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
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,223,639
Messages
6,173,498
Members
452,516
Latest member
druck21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top