If you copy it down adapted to the real cell references it will return that
particular value, you could also use

=AND('data'!A1=0,'data'!B1="SD-FREE")

copy down will return TRUE or FALSE then you could apply autofilter and
filter on TRUE

another way would be to use

=INDEX(C2:C200,MATCH(1,(A2:A200=0)*(B2:B200="SD-FREE"),0))

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom

(No private emails please)


"darkwood" wrote in
message ...

bump, I am getting desparate!

TIA :)


--
darkwood
------------------------------------------------------------------------
darkwood's Profile:
http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=496451