I have a large list which I want to use two different criteria to find
one unique row. I was able to achieve this using the Autofilter
command (perfect with the drop down menu, just what I wanted), but the
problem that I'm having is that the data that I get, I want to use the
value for a formula.

Here is an example:

Size OD ___Weight ____m³/m
101.600 ___8.40813 __0.0070573
101.600 __13.78040 __0.0063858
101.600 __14.13756 __0.0063786
101.600 __15.56620 __0.0061223
114.300 __10.77431 __0.0088873
114.300 __11.83090 __0.0087520
114.300 __12.85774 __0.0086178
120.650 __10.58085 __0.0100792
120.650 __10.78919 __0.0100795
120.650 __14.13756 __0.0096500

(the __ is used to seperate the columns)

I want to be able to pick a Size OD, and a weight, and come up with a
unique value for m³/m. This I can do with autofilter, but the cell
that contains the m³/m data keeps changing, since autofilter only hides
cells and doesn't move the data. Is there a way that I'd be able to
automatically take the data from the filtered m³/m column to go into a
formula?


--
Zaraf
------------------------------------------------------------------------
Zaraf's Profile: http://www.excelforum.com/member.php...o&userid=36291
View this thread: http://www.excelforum.com/showthread...hreadid=560718