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[TABLE="width: 500"]
<tbody>[TR]
[TD][Delaware][/TD]
[TD]Standard Oil[/TD]
[TD]Y[/TD]
[TD]Reeves[/TD]
[TD]Bone Spring[/TD]
[TD]20000[/TD]
[/TR]
[TR]
[TD][Midland][/TD]
[TD]Standard Oil[/TD]
[TD]N[/TD]
[TD]Martin[/TD]
[TD]Wolf Camp[/TD]
[TD]15000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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 ?