Hello Everybody

I am trying to use the IF command in order to show a certain cell if it
has got a certain value. I want these values to be shown in a an other
sheet in the workbook but i always get some blank lines.
The command i am using is:
=IF('sheet1'!H4="non conformance";'General'!D4;"")

I know that the "" i am using gives the blanc space. But is there a way
that i can avoid that and the answers are placed without the gaps?

Kind Regards


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

using the INSERT FUNCTION formula way that way the formula cannot be
written wrong also i see you have ; specified in your formula try ,


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

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