If function "logic test" to read the value in a formula.

[markDuffy]

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

[bebo021999]

In some cases, there are space(s) before or after the text.
So try this:
IF(TRIM(P770)=TRIM(ControlSheet!T204),....)
to avoid rid of space.
If it does not work, try to upload small example.

[Norie]

Mark

A formula will not read the formula from a cell it references, it will read the value.

If you aren't getting the expected result(s) it could be because there's no match.

[markDuffy]

Thanks for all this i will check it out. At least now I know where I am going.