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.
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
Last edited by jpleonardo; 04-08-2021 at 06:48 PM.
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)
I used your equation but swapped the row number to what I have value wise and it is working so far! Thank you so much. This was the beginning to the end of my overall calculations. Very much appreciated.