OandGmodeling
New Member
- Joined
- Apr 5, 2019
- Messages
- 8
Hello,
I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having much luck. I am also trying to make the formula flexible since the data range will likely change on a weekly basis. My lookup values are from the model and are presented in the exact same text as in the raw file. Thanks!
Here is the formula I am using that is returning a #VALUE error when not used as an array, which I would prefer not to use if possible:
=INDEX([Rigs_04012019.xlsx]Rigs!$C:$C,MATCH($B$103&B$104,[Rigs_04012019.xlsx]Rigs!$A:$A&[Rigs_04012019.xlsx]Rigs!$B:$B,0))
<tbody>
</tbody>
I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having much luck. I am also trying to make the formula flexible since the data range will likely change on a weekly basis. My lookup values are from the model and are presented in the exact same text as in the raw file. Thanks!
Here is the formula I am using that is returning a #VALUE error when not used as an array, which I would prefer not to use if possible:
=INDEX([Rigs_04012019.xlsx]Rigs!$C:$C,MATCH($B$103&B$104,[Rigs_04012019.xlsx]Rigs!$A:$A&[Rigs_04012019.xlsx]Rigs!$B:$B,0))
Play | Operator (reported) | Drilling | Formation | County | Depth |
[Delaware] | Standard Oil | Y | Reeves | Bone Spring | 20000 |
[Midland] | Standard Oil | N | Martin | Wolf Camp | 15000 |
<tbody>
</tbody>