Dear experts.
My requirement is as below.
In a excel file i want to enter the formula which refer to the cell. The data written in the cell refer to some other worksheet.
The formula should give the final result of the cell in the other worksheet.
For Example
below Data is written in cell A1 and A2 and A3 of worksheet "june" and in another worksheet named "May" 9876 is entered in cell number D45.
Cell A1 Data is "May"
Cell A2 Data is "D" This D should correspondence to the Column D of the Worksheet named "May"
Cell A3 Data is "45" This 45 means the formula should correspondence to the Row 45 of the worksheet named "May"
Requirement for the formula
We need to use the formula in cell A4 and the result of the formula should be 9876.
thanks in advance.
Bookmarks