Multiple Search and multi return

[erlisocial]

Hi all

I am looking for a multi search and multi return on 3 different criteria

Photo 1 is my Search sheet and Photo 2 is the dummy data

When I enter the criteria in Search D3 / D4 and D5 I would like the data to populate on the table B8:F15. Please note in the Data sheet, all the columns are named ranges.

Can someone please help and advice which is the best way to tackle this to achieve fast return on the data?

Many thanks in advance

 

[MUKESHY12390]

this would solve your problem. follow link it has very nice demo...Click Here..