Transfer data between two tables

Joined
Dec 4, 2022
Messages
12
Reaction score
0
I have two tables and want to transfer data from one to the other.

1693643084891.png

Examples:

When I write the letter D in cell A9, the value from cell H3 (30) should be fetched to cell B9 or
if I write the letter A in cell A9, the value from cell E3 (0) should be fetched to cell B9 .
Is this possible? And what is the function/formula in that case?

/hans peter
 
Top