Excel and Vba: comparing couple of data

[Nelson78]

Hello everybody.
I'm in the situation you can see in the link:

https://imgur.com/a/fRxpUnM

In Cartel1 initially only column A is populated, then we have to refer to the sheet name in order to compose couples of data (1111Red, 1112Red, 1113Red, ...) comparable in Cartel2 to the combination of column F&J (so we have 1111Red, 1112Green, 1113Gray and so on).

Then, looking for the couples of data Cartel1 in the list of couples of data in Cartel2 (there is only 1 correspondence), in column H Cartel1 we have to transcribe the value of column F Cartel2 (see cells written in red).

I think it is a game of arrays and dictionaries, but I need some hints.

Thank's in advance.

 

[Nelson78]

Hello everybody.
I'm in the situation you can see in the link:

https://imgur.com/a/fRxpUnM

In Cartel1 initially only column A is populated, then we have to refer to the sheet name in order to compose couples of data (1111Red, 1112Red, 1113Red, ...) comparable in Cartel2 to the combination of column F&J (so we have 1111Red, 1112Green, 1113Gray and so on).

Then, looking for the couples of data Cartel1 in the list of couples of data in Cartel2 (there is only 1 correspondence), in column H Cartel1 we have to transcribe the value of column F Cartel2 (see cells written in red).

I think it is a game of arrays and dictionaries, but I need some hints.

Thank's in advance.

Help please.

 

[Nelson78]

Help please.

No suggestions?