Index Match Across Workbooks and Multiple Criteria

[OandGmodeling]

Hello,

I am trying to pull certain data from a raw 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) 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. Below is an example, with exact formatting on the raw file, that I am dealing with. This should be rather simple I feel like but I keep getting errors. Any help would be appreciated. Thanks.

Column A

[Delaware]	Standard Oil	Y	Reeves	Bone Spring	20000
[Midland]	Standard Oil	N	Martin	Wolf Camp	15000

<tbody>
</tbody>

 

[etaf]

you could use the full columns , then it wont matter when updated


=INDEX(RawFileName!$C:$C,MATCH(A2&B2,INDEX(RawFileName!$A:$A&RawFileName!$B:$B,0),0))

Not sure exactly what you want - New File NAme or Sheet name
If a seperate workbook file name is that going to be open at the time of updating ?