Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find formula for.... | Excel Worksheet Functions | |||
Need to find the right formula | Excel Discussion (Misc queries) | |||
Need to find a formula | Excel Worksheet Functions | |||
Need Help With A Find Formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |