Find a value in a table based on two lookup values in range

[spooki3]

Hi,

I haven't been able to find the solution the my problem so hopefully someone will be able to help me. I have been struggling with this problem for about two weeks now.

I have and administration of all connections of a system on sheet 1 and an export of the connections on the system itself on sheet 2. For the export on sheet 2 I would like to find the corresponding connection on sheet 1 if it exists and show an empty cell if not data is found.

Sheet 1 containing the administration looks as follows:

ConnectionName	Environment	account1	account2	account3
Connection 1	A	user1
Connection 2	P	user1
Connection 3	P	user2	user3
Connection 4	A	user4	user5	user6
Connection 5	P	user4	user5	user6
Connection 6	P	user8

<tbody>
</tbody>

Sheet 2 containing the export of the system looks as follows:

Environment	Account	ConnectionName
A	user1
A	user5
P	user5
P	user7

<tbody>
</tbody>

On sheet 2 column C (ConnectionName) I would like to display the name from sheet 1 column A where both the environment from sheet 2 matches with the environment from sheet 1 and the account from sheet 2 matches with the account from sheet 1 in the range C2:E7

So user5 environment A should display "Connection 4"
user5 environment P should display " Connection 5"

I have been struggling with INDEX MATCH functions to find the correct solution and have only been able to find a solution if the users are unique which unfortunately isn't the case. I am open for a VBA solution. Any help would be greatly appreciated.