Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you help to find the right formula?
Hi,
I published this message on the Programming forum, but I'm not sure if the solution may come out from here as well, so... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |