![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
How to make it auto fill-in the value(column C2) to column between column F2 to column K2 whitch is matching column E2 with between F1 to K1 :-
C2 - 3000 E2 - JULY (WHITCH I KEY IN) F1 - JULY G1 - AUGUST H1 - SEPTEMBER I1 - OCTOBER J1 - NOVEMBER K1 - DECEMBER If i key in JULY at column E2, so the value(C2) will auto fill-in to column F2 whitch is matching E2 & F1, by the same time, when i key in SEPTEMBER at column E2, the value of C2 will auto fill-in to column H2. thanks for help Daniel Law |
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Data Validation/Lookup function does function correcty | Kirkey | Excel Worksheet Functions | 2 | May 25th 09 09:22 PM |
| copy of excel file not showing formulal/function in the function b | oaallam | Excel Discussion (Misc queries) | 4 | September 6th 07 01:20 PM |
| Excel - User Defined Function Error: This function takes no argume | BruceInCalgary | Excel Programming | 3 | August 23rd 06 08:53 PM |
| Adding a custom function to the default excel function list | DonutDel | Excel Programming | 3 | November 21st 03 03:41 PM |
| When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Niek Otten | Excel Programming | 2 | September 18th 03 03:55 AM |