Help with a dynamic filtering table

Hello everyone. I work for a engineering company and I have this large excel sheet that is a dynamic filtering table. SO that works just fine. It's very large and intellectual property so i cant put it up but here's what the layout is like:

List (filter) - model number variable (filter) - variable a - variable b- variable c - variable d - variable e, etc
**filtered options below

So if I want a specific list variable and model variable to achieve variables a-e, I filter it and then I get what i needed. That's all dandy however i want that one row of the needed variable and options chosen to populate in a different sheet in a table respectively. This is important because this the sheet that does a million calculations and formulas.

What I have tried so far hasn't worked, "vlookup" "filter" "power qeury" etc... even just "='thatsheet'!cell

Anyone know how to make this work anytime I filter everything down to the one model I want. Remember that the cells change every time I narrow it down to that one model.

THANK YOU>
excuse all grammar mistakes, I'm lazy...

I WILL IF NEEDED OUT A SAMPLE OF THE LIST, BUT ITS A PRETTY STRAIGHT FORWARD FILTERED LIST

In general, a sample sheet (however simple you THINK it needs to be) is ALWAYS better than nothing. So this dyamic array is a wild guess, based on my interpretation of your words.

=IFERROR(INDEX(Sheet1!A:E,AGGREGATE(15,6,ROW(Sheet1!A$2:A$100)/(SUBTOTAL(3,OFFSET(Sheet1!A$2,ROW(Sheet1!A$2:A$100)-ROW(Sheet1!A$2),,,))=1),ROW($1:100)),SEQUENCE(,COUNTA(Sheet1!$1:$1),1,1)),"")

see sheet. It returns all visible rows (so, only one if filter(s) are applied that lead to a unique result. It will result in a SPILL error if you put ANYTHING else int he pale green shaded area (it's currently set up to return visible cells from a 100 row table)

Great. If you hit a problem, shout.

However, for now you're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.