I need the formulae to:

1. Look at specific cell in different worksheet and see if it has a
value.
2. If it does, I want to pull the whole row into the worksheet that I
am working in.
3. But if it doesn’t have a value, I want my formulae to then check the
same cell in the next row down to see if this has a value. It it does,
same as point 2 above applies. , If not, it needs to again check the
next row down.
4. This checking needs to continue until it comes across a value.

I am guessing (hoping) that there is some sort of array look up formula
that can be used

thanks for any help..........I am drowning.


--
George.
------------------------------------------------------------------------
George.'s Profile: http://www.excelforum.com/member.php...o&userid=35028
View this thread: http://www.excelforum.com/showthread...hreadid=547768