display cell in another if cell = specific text - formula in 3rd cell

[NCopernicus]

Hi ...

My formula sits in one cell (eg-Q26) checking the value of another cell (R16) after an input in a completely different cell (k11).. If R16 = "No Suburb" then i want K11 to display "No Suburb"
Can you please help with the tweaking of the formula i have used.

CELL Q26 formula reads .... =IF(R16="No Suburb",K11," No Suburb")

[AliGW]

Cell K11 can either hold a formula or be an input cell - it can't be both, so what you are trying to do, if I have understood correctly, is not possible. Your formula:

=IF(R16="No Suburb",K11,"No Suburb")

means if R16 contains the words "No suburb", return the value of K11 in Q26, other wise return the words "No suburb".

[NCopernicus]

Thanks, bit disappointing, but thanks for replying. back to the proverbial drawing board.

[AliGW]

You'll have to learn the black art of VBA to do that sort of thing!!!

Glad to have helped.

[NCopernicus]

Thanks Ali

somehow i knew that VBA would rear its somewhat ugly head, oh for the days of C64 Basic.