| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to take the worksheet name as a variable(Label/Define) in a fo
Hi,
I have 12 sheets for each month of the year. The Sheets has been names JAN, FEB, MAR€¦DEC. I added one more Sheet Analysis. In the Analysis Sheet, there is a list containing 12 entries JAN, FEB, MAR€¦.DEC. I want to do some calculations based on the user selection(JAN or FEB or MAR etc). The formula I am using is =IF(((VLOOKUP(B4,MONTH!$G$2:$G$245,1,FALSE))=B4)," Y"," "); here MONTH should be a variable based on the selections. Please help me in this( I am expecting a solution without using macros ). This is an urgent issue. Thanks and Regards, Subin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Threaded Mode
