Update cell with value based on multiple criterias

L&G

I’ve been pondering on how to make a time-consuming task more efficient. Me and the group spend hours and hours each month manually creating statistics and trendlines, but there must be a way to automate this in excel. So far no luck.

Attached an example of what we are trying to do. Either using formula or VBA, we are in need to saving some time doing our work, and hope someone can help us solve this.

Sheet 1
We want to automatically populate numbers in cells below the ones in sheet1 highlighted in red. Matching criteria’s example;
- Sheet1 A5 = Sheet2 F1:R1
- Sheet1 B5 = Sheet2 F4:AA4
- Sheet1 C5 = Sheet2 F5:AC5

If all 3 at matching, then we know the required number in this cell is located in 1 specific column. Then we need to find the required cell value from

1) sheet1 (in G3:J3) to match
2) sheet2 B6:12
3) then find number in F6:AC12

So, if date + check# + rheology# all match, then if formula is in sheet1 cell G5, the value to show would be "83" (which is in sheet2 cell F12).

This example is only a fraction of all the data required, it can run up to 30 days, and input values can be up to 200. So worst case, 200*30 inputs…

I hope I have explained this well enough, and i hope it is possible. I do realise it will be some work to create this the first time, but that will be saved in quickly for sure.
We've been trying with index and match functions, but keep getting #N/A results... Not tried anything in VBA yet.

Any help or suggestions are most appreciated!