Hello all,
Here is the situation, i have a index search formula i have in a column. The problem is that they are wanting the value in the cell to just be the result of the formula and not the formula or a formula. I can't have the formula anywhere else on the sheet so the next best thing would be to add the formula to vba coding and have it run the formula and just add the value to the result into the cell. Here is the following formula for row 2
=INDEX('Data Table'!$C$4:$F$12,MATCH(Assessment!L2,'Data Table'!$B$4:$B$12,0),MATCH(Assessment!N2,'Data Table'!$C$3:$F$3,0))
The two sheets in excel are titled 'Data Table' and 'Assessment'.
Please let me know what type of code i can do in order to give me just a value located within the Data Table. Thank you.
Here is the situation, i have a index search formula i have in a column. The problem is that they are wanting the value in the cell to just be the result of the formula and not the formula or a formula. I can't have the formula anywhere else on the sheet so the next best thing would be to add the formula to vba coding and have it run the formula and just add the value to the result into the cell. Here is the following formula for row 2
=INDEX('Data Table'!$C$4:$F$12,MATCH(Assessment!L2,'Data Table'!$B$4:$B$12,0),MATCH(Assessment!N2,'Data Table'!$C$3:$F$3,0))
The two sheets in excel are titled 'Data Table' and 'Assessment'.
Please let me know what type of code i can do in order to give me just a value located within the Data Table. Thank you.