Same Formula / Different Cell - not working

**mikeexceltip** · 08-03-2009, 04:15 AM

I'm trying to use a formula for column F, starting in cell F6, for column M, starting from M26. The formula works in Column F but after I tried to use it in column M with adjustments, it doesnt work...

Can anyone please find what did I do wrong?

Thanks!

Attached is the file...

Mike

**DonkeyOte** · 08-03-2009, 04:26 AM

As you have it the LOOKUP function should look from the first row to the preceding row at any given point - in column M you have the LOOKUP referencing the current row thus generating circular errors (eg M952 should reference only up to M$26:M951)

**Andy Pope** · 08-03-2009, 04:30 AM

It's not the same formula as it contains a circular reference problem.
Due to the reference to $M$26:M27

try,

=IF(IF(K27=1,IF(L27=1,"BUY","SELL"),0)=LOOKUP("zzzz",$M$26:M26),0,IF(K27=1,IF(L27=1,"BUY","SELL"),0))