Hi folks!
I have a formula that i'm trying to convert into VBA.
Formula =INDEX(Jobs!$G:$M;IFERROR(MATCH("HoF*"&$C$7;Jobs!$B:$B&Jobs!$C:$C;0);MATCH($C$7;Jobs!$C:$C;0));1)
Anyone can help me on this please.
Thank you in advance
Hi folks!
I have a formula that i'm trying to convert into VBA.
Formula =INDEX(Jobs!$G:$M;IFERROR(MATCH("HoF*"&$C$7;Jobs!$B:$B&Jobs!$C:$C;0);MATCH($C$7;Jobs!$C:$C;0));1)
Anyone can help me on this please.
Thank you in advance
What do you mean by "I have a formula that i'm trying to convert into VBA."?
First question: Why? Second question: Where is the output to go? third question: Do you just want values; is this for performance?
It looks like an Array Formula with full column references so performance is likely to be poor. Use Dynamic Named Ranges or a Structured Table to minimise the number of cells involved in the calculations.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry about the confusion...
Where is the output to go? The formula is now sitting in (Custom) sheet at the cell (C10).
The formula now in it is =INDEX(JobsStats;IFERROR(MATCH("HoF*"&$C$7;JobsBatchNo&Jobs;0);MATCH($C$7;Jobs;0));5)
Why? Because in VBA with other condition... the cell formula might change or even not be any formula. Less confusion with formula and also easyer to manage.
Do you just want values; is this for performance? To show value in cell... yes... to perform faster... yes.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks