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

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

Hi Eduardo,

Thanks for offering to help out.

It's actually a 2 part problem.

1st part is where

IF information from cellA of sheetA is X, then information relating to cellA
of sheetA is then transferred to sheetB.

2nd part:

But if cellA of sheetA has no information, it results in sheetB returning a
0, then information from cellB of sheetA will be transferred to same cell in
sheetB.

So the formula
=if(sheetA!A1=0,sheetA!B1,sheetA!A1) is not really correct, cos it means
that i have if sheetA!A1 not = 0, then sheetA!A1. But what im trying to
achieve is to trigger a 2 part ONLY if sheetA!A1=0.

Ivan

"Eduardo" wrote:

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

Hi,
I assume if cell A is X you don't want to populate anything so

=if(sheetA!A1="x",sheetA!A1,if(sheetA!A1=0,sheetA! b1,""))

Change the range where you want to pull the information if A1 i="X" to fit
your needs

"Ivan Koh" wrote:

Hi Eduardo,

Thanks for offering to help out.

It's actually a 2 part problem.

1st part is where

IF information from cellA of sheetA is X, then information relating to cellA
of sheetA is then transferred to sheetB.

2nd part:

But if cellA of sheetA has no information, it results in sheetB returning a
0, then information from cellB of sheetA will be transferred to same cell in
sheetB.

So the formula
=if(sheetA!A1=0,sheetA!B1,sheetA!A1) is not really correct, cos it means
that i have if sheetA!A1 not = 0, then sheetA!A1. But what im trying to
achieve is to trigger a 2 part ONLY if sheetA!A1=0.

Ivan

"Eduardo" wrote:

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