toMarsandBack
New Member
- Joined
- Dec 26, 2016
- Messages
- 3
I've been searching high and low for a formula that will return a value from a table based on multiple factors (seems to be some combination of IF and Vlookup formula). I looked through the forum to see if anyone has already posted a question similar to mine but I didn't find an exact match (is an excel formula as unique as a snowflake?) Anyways, with that being said, I understand that the people providing help on this forum have to take time out of their day to come up with answers so I'm more than willing to make a donation to the forum. I've spent way too much time on this and just need a good answer at this point.
Sheet 1
<tbody>
</tbody>
<tbody>
</tbody>
I need a formula that will use values in the Opponent and Position columns in sheet1 - in this case MEM and PG - and return the corresponding value - in this case Mike. Simply put, Mike is the Memphis PG that is guarding the Lakers PG.
Sheet 1
Player | Position | Team | Opponent | vs. player |
John | PG | LAL | MEM | ????? |
Mark | SG | LAL | MEM | ????? |
<tbody>
</tbody>
Player | Position | Team | Opponent |
Mike | PG | MEM | LAL |
<tbody>
</tbody>
I need a formula that will use values in the Opponent and Position columns in sheet1 - in this case MEM and PG - and return the corresponding value - in this case Mike. Simply put, Mike is the Memphis PG that is guarding the Lakers PG.