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.


Participate now!

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