Hi,
I am having trouble with the following index match formula in VBA. Following is the code
Please Login or Register to view this content.
The UDF refdate is a date vale in formate m/d/yyyy & discat is a text stirng.
the z is showing the right concatinated value for x & y. but when it goes to MATCH formula , its says FALSE.
and subsequently the index formula fails.
I think it has something to do with variable defination.
Any suggestion??
Bookmarks