Matching with multiple criteria/dynamic range

Hi Timgis,

Please attach the Excel file, it would be easier to understand.


Thanks
Nisha

Thanks for the advice, I've now created a dummy workbook that I hope shows what kind of procedure I am talking about. Please find the workbook attached. I've tried to show the steps that I would like to automatize in Excel.

Let me know if I can make anything clearer!