XY Look up function for Excel range. Return array of results to VBA subroutine
Any direction or help would be appreciated. I have attached a file for you to look at. What I need is basically a XY table lookup in VBA BUT there can be more than 1 result. And I need it to ignore blank values and blank lines.
For example, if I pass Joe and Period 4 to the funciton. I would expect an array back with 2 elements of France, .75 and Italy, 1