Pulling data from a range referenced in two cells

Hello Excel Forum,

I'm currently constructing a workbook that can have data from an automated report be pasted in, and statistics be automatically generated. I've got everything that I need, except for two things:

1) I would like, in the "QA Stats" worksheet, to have Excel automatically generate any placements that are outside the range specified in the cells under "Clickthrough Rate". These will be generated in that worksheet from the "Query" worksheet. If the range cells were to be changed, the results would change with it.

2) Instead of having a static table under the "Impression %'s", I would like all unique placement categories to be generated in the table automatically. This will allow for placements that don't exist in the report to not show up in the "QA Stats" worksheet. Then, the %'s would be calculated (those are already done!).

I've been struggling for a few days now figuring out these last two parts, and would greatly appreciate any help whatsoever! I've attached a generic version of what I'm working on as reference.

QA Tester III external.xlsx

Thanks for your help here! I attached an updated file with what a mock up after it's run would look like.

1) As seen in the "QA Stats" worksheet, it should show any row that are outside that specified Click Rate range. If the Click Rate range cells were to be changed, then the rows from the "Query" sheet that show up in the "QA Stats" sheet would change as well.

2) You're correct in that B14:B18 are the placement categories. That's the complete list, but I don't want ones that aren't in that current report to be shown, just for neatness' sake. They don't relate to the placements in the Query tab, because I changed it all to generic data for business confidentiality.

Refer to "QA Tester III external.xlsx" for the most up-to-date one. Apologies for the confusion there...

Bumping for awareness. I'm in desperate need of help on this

Thanks, it works like I wanted! One thing: is there any way to have the "Impression %'s" table display the placement/ad default names after the vlookup instead of 1,2,3, etc.?

I really appreciate the help here, life saver!