Can you help to find the right formula?
 

Hi,

I have two WS, say WS1 and WS2

WS1

A B C D E

1 GARY MIK JOHN 1000 700
2 GARY SANDY BRIAN 500 300

The data in column D & E are values that a user inputs.
When the user inputs D1, I want 1000 to go to WS2 where at row level the
same 3 constants can be found.
So, 1000 should go where in WS2 there are rows with the three words GARY,
MIK, JOHN.

WS2

C D E F G

1 ANDY ELLEN KEVIN
2 GARY SANDY BRIAN
3 GARY MIK JOHN 1000

In this way any value that the user inputs in WS1 D or E columns will go
automatically into WS2 where the three combination of values are found at row
level.
Please, bear in mind that although the WS1 columns D and E and WS2 columns F
and G have respectively the same heading name.
Once again, if user enters in WS1 the value for E2, then 300 should
automatically end up into WS2 G2.

I dont't know if this can be done programmatically or by a particular fx
function in Excel, but I'm sure you can help.

Thank you
Metallo