| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lOOK UP VALUES
i HAVE SHEET LIKE THIS FILE NAME AS ADVANCE FILE
NAME JAN FEB MAR APR JUN JUL AUG ............... JOHN 100 200 300 400 200 200 200 KATE 200 200 200 200 200 200 200 LAURAL 200 200 300 300 300 300 300 IN PAY ROLL FILE I WANT TO DEDUCT THE ADVANCES MY SYSTEM SHOULD TAKE AUTOMATICALLY THE VALUES IF I TYPE JAN IT SHOULD TAKE JAN VALUES AGAINST JOHN, KATE AND LAURAL IF FEB, FEB VALUES AND MAR, MARCH VALUES.......... ETC CAN ANY ONE HELP ME IN THIS ........PLEASE SRINIVAS -- srinivas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Threaded Mode
