Hi there.

I am trying to write an Index Match array equation, which uses performs a Match for a data range:

EXCEL FORUM HELP.png

Where the RANGE is every integer from 600 to 630. This would be repeated for each cell across.

The idea here is that while the values is Column A and Column B will be exactly matched in the array, the values in Row 1 will fall within the specified ranges, and I would like the function to pick up any matches within that range.

Taking this one step further (perhaps this needs VBA), is that where there is more than one match, I would like the cell to list each of the matches.
For instance, it could have the following matches:

Mon AB 605
Mon AB 615
etc.


I have not used VBA in excel before, but have former VB experience, so could reverse engineer code if someone knows how to write this into VBA.

Many thanks!