VBA for loop to loop through index/match Array

[bjjc51192]

I have the following array formula:


={INDEX(r_base_liability,MATCH(1,("Liability"=r_peril_liability)*(i_score=r_score_liability)*(i_liabilit_bucket=r_terr_liability),0))}

This performs a 3 way look up, and so far it is working fine.

However, I want to loop through the parameters i_score, and output the i_score that led to an N/A value if no N/A value occured, I want it to print " No N/A".

I know how to do this for a non array process, but not sure how to get vba to deal with an array function,

thoughts?

 

[James006]

Hi,

Within VBA you can use Evaluate to come work out the result of your Array formula ...

Hope this will help