So here is the basic problem, I have a table "vwSVC_RegTool" that is stored in an xlam. I am trying to create a macro that will check 2 ranges, Yearlk and Svclk and find the resulting value.
Basically how this work is, it uses an index match along with the evaluate function to get the information. If i run it as a macro not in an xlam it works fine. Once i put it in an xlam it cannot find the tables. I am thinking the only thing i need to do is change how i reference the xlam tables. However, i cannot find this information anywhere.
Dim Exists as Variant
Exists = Evaluate("=INDEX(vwSVC_RegTool[service_code_id],MATCH(1,(vwSVC_RegTool[term_year]=yearlk)*(vwSVC_RegTool[service_code_id]=svclk),0))")
If Exists = Range("svclk").Value Then
Basically how this work is, it uses an index match along with the evaluate function to get the information. If i run it as a macro not in an xlam it works fine. Once i put it in an xlam it cannot find the tables. I am thinking the only thing i need to do is change how i reference the xlam tables. However, i cannot find this information anywhere.
Dim Exists as Variant
Exists = Evaluate("=INDEX(vwSVC_RegTool[service_code_id],MATCH(1,(vwSVC_RegTool[term_year]=yearlk)*(vwSVC_RegTool[service_code_id]=svclk),0))")
If Exists = Range("svclk").Value Then