VBA for returning a string from an array when given 2 references

  • In the attached picture is the area of sheet(Data) that I am using.
    See also my named ranges
    and the data supplied.
    The formula works fine in a cell of the worksheet, but i am getting error 2015 when used in VBA.
    Can someone correct my error ??


    Many thanks in advance.




    [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"asasas.png","data-attachmentid":1206237}[/ATTACH]


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!