Converting a formula into vba coding

zoog25

Active Member
Joined
Nov 21, 2011
Messages
418
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.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
if you do it infrequently, run your formula, then copy paste value
 
Upvote 0
I can't. The sheet/program i'm running is monthly and currently 75,000 rows. So copy and pasting each one is out of the question. That is why i want a code because i'm going to add it to a certain point in my program that when i loops through each row, it will calculate the value in the cell based on the table.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top