Auto filter -using output

[skelly22]

Hey all
I have a spreadsheet with a column of beam sizes with their respective data in the columns beside them.im using auto filter so that i can select one particular beam and bring up all that data in one row. I then wish to perform calulations on the row. How ever when i select a new beam size my formula values do not change.
Can someone please tell me how to get my formula to reference the respective beam im selecting?
Thanks
shane

 

[pmover]

the autofilter lists values meeting the criteria in the same row; whereas, the cell formula referencing the beam criteria is the same and is different from what the auto filter lists.

try using the index function instead. the input array is list of beams, but have the row/column return the value of the respective beam data. then have the formula referencing that particular beam be the cell returning the beam criteria.

hope this helps . . .

good luck!
-pmover