I have a formula that looks like this:
{=MIN(IF(SHEET1!A2:A400=SHEET2!A4,SHEET1!B2:B400)) }

What I would like to do is instead of saying A2:A400 and B2:B400 I
would like to do A:A and B:B. When I do this my results turn to zero
because the cells are blank beyond 400.

Is there a way I can write the formula to ignore the blank cells.

Any Help Would be appreciated!!!


--
rmeister
------------------------------------------------------------------------
rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=498681