Maybe just change the 0 to "" which will leave the cell looking blank.

=IF(AND(Sheet2!N6<0,Sheet2!B6="North"=TRUE),Sheet2 !A6,"")


Gord Dibben MS Excel MVP

On 18 Dec 2006 03:30:47 -0800, wrote:

Hello!

I am unsing the following formula to pull in values from a spreadsheet.

=IF(AND(Sheet2!N6<0,Sheet2!B6="North"=TRUE),Sheet 2!A6,0)

i am getting a list of "0" values. how can i move to the next cell
below, only returning values for 'true' formulae.

cheers

nick