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:
<tbody>
</tbody>
Sheet 2 containing the export of the system looks as follows:
<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.
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.