insert this code

=vlookup('sheet1'!H4="non conformance",'General'!D4:D100,1,false)


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=550240