Hi Guys
Good afternoon
I am trying to create a formula which can read the value of the cell it is referring to not the actual formula.
=IF(P770=ControlSheet!T204,ControlSheet!U204,)
P770 is Post Office Ltd
ControSheet T204 translates to Post Office Ltd.
ControlSheet U204 gives Stationary & Postage In this case it works fine.

But there are occasion in my worksheet where the value in the P column is ='Petty cash'!C23 (or another cell in that sheet but in column C)which in this instance is also Post Office Ltd but my return is 0.

I am sure that the answer is dead simple but despite my attempts with my limited experience I cannot find a way round.

All the Best Mark