VBA function to almost replicate xlookup but return array

So I have two columns Material, and Process. The user selects a material and i need a function to look in a different sheet for all process matches to that material. Example would be a user picks Steel, and the the value returned is an array containing all processes that have the material steel. This shouldn't be too hard for someone better than I am at VBA coding, but I'm lost. Below is what ive tried and it just returns "0"

Please Login or Register  to view this content.

Hi there,

Take a look at the attached workbook and see if it gets you moving in the right direction. It uses the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

And the following code in the VBA CodeModule of the "Materials" worksheet:

Please Login or Register  to view this content.

The highlighted value may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M