'Microsoft Excel function to capture value from other sheet
I'm trying to figure out which Excel function is appropriate to accomplish the following. Any assistance is appreciated!
I have two sheets in Excel; one called 'Master' and one called 'Data'. As you'll notice by the screenshots, the Master sheet has a distinct list of Index/Names, while the Data sheet can have multiple instances. What I'm looking to accomplish in this example, is look in the Data sheet to find instances where the Field = "Broker" and Value = "Yes", and have "Yes" automatically populate in Column C of the Master sheet; connected to the appropriate Index.
It's worth noting that the Broker field can only show up as "Yes" once per Index/Name. So, there's no chance of collision.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|