I created an Index/Match array forumula in the worksheet. It works.
I'd like to transfer this to vba and set a variable to the answer of the formula all within VBA. See below for an example of what i'm trying to do.Please Login or Register to view this content.
The above obviously doesn't work, Is this type of thing possible though??Please Login or Register to view this content.
Bookmarks