Transfer data between two tables

[hans peter]

I have two tables and want to transfer data from one to the other.

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

 

[hans peter]

I realize the difficulties and abandon the project.
/hans peter

 

[Harry Potter]

I think you did good by abandoning it.

 

[hans peter]

I realize the difficulties and abandon the project.
/hans peter

Here is the solution: =XLETAUPP(A9;$E$2:$H$2;$E$3:$H$3;"")
/hans peter