Lookup for value with multiple IDs repeating in same columen

[pupek]

Hello,

I am new here and hope you can help with with my problem.

We have an output from attendance system (is mostly up to 200-300 rows) and need this data to use/input in another file without adding in manually and checking if assigned values to the correct cell.

I create connection with that file and want to work via refresh so I am looking for formula that will check "Line 1,2,..." -> then if its "Internal/Eternal/Temporary" -> and then specific group "A,B,C" and insert value from 2nd column.

Issues I can't do anything about it:
- all 3 conditions are in same column
- 2 IDs are being multiplied such as Internal/External or A,B,C ..
- locations are not fixed e.g. can be that one day there will be no External employee from Line 1 and subgroup B (so this row wont be in the output) so then also the only changeable condition such as Line 1,2... can be in another row

Found somewhere solution with INDEX/MATCH/INDIRECT formulas for 2 conditions such as:
=INDEX(B:B;MATCH(A4;INDIRECT("A"&MATCH($A$2;A:A;0)+1&":A50000");0)+MATCH($A$2;A:A;0))

Couldnt find out how to extend it into 3 condition system and dnt quite understand that INDIRECT formula there.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Line 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Internal
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]5 [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]External[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Internal[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]External[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Temporary[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]