Hi,
your explanation comparing with the formula is a little confusing, as per
your explanation you should enter in sheet B cell A1
=if(sheetA!A1=0,sheetA!B1,sheetA!A1)

Please if that is not the answer you are looking for please explaing what is
in each cell of the formula given and what you want to achieve. thanks



"Ivan Koh" wrote:

Hi all,

Thanks for your help the last time round. Got yet another problem.

Would like to pull data from cell A from worksheet A to cell A of worksheet
B when a certain condition is met.

However, when if information from cell A to worksheet B is 0, then i would
automatically like to pull information from cell B of worksheet A to cell A
of worksheet B.

Thus, i was wondering if the formula of cell A for worksheet B would be
something like
'=IF('A'!G14="X",'B'!F14,"")=IF(E7="",'B'!E14,","-")

But i get a error on circular reference. Any idea?

Ivan