Need VBA or macro to do a advanced lookup function

[forginganewone]

What i want is to be able to use VBA or excel in a new sheet which will take following criterias : sheet name from H2 column( sheet 1), site from A2 column (99), discription from G2 column (cable) and number of rows from F2 column (3).

The trick here is number of rows, as the site id and description will be same for each row in that sheet but other data will be different so i want it to populate 3 rows without repeating any row.

Result : The result going in a new sheet.
Criteria : only two criteria from A2 and G2. H2 is sheet name from which data will be searched and F2 is number of rows which should be picked.
Searching : I will be searching in a sheet with multiple columns.

The column of A2 and G2 will be same in that sheet but other coulmns data will be different, so i want a script of formula to search and pick number of rows(F2) on criteria A2 and G2 but do not duplicate the rows.For example value in F2 is 3, the script/forumla will pick 3 unique rows from sheet(H2) on criteria A2 and G2

Please find sample data here : https://expirebox.com/download/edf2c...b03667b11.html

Breakup sheet : from where formula will take criteria from
Cables sheet : from where it will search data
Results sheet : Where output should be given

Please note that i want the script to populate all the results of data in breakup sheet.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...criteria-without-duplicating.html#post5103039

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.