Find Text in Range of Cells and Autofill required Text in different worksheet

[SOLVED]What formula should I use if I want to automatically replace certain text ("MATHS") in a cell (C29 in SHEET 2) if with condition found certain text (e.g. BA101) within a range of cells (C3:C52) in SHEET 1?
Please refer attachments for details.[/SOLVED]

Hi ade2tay,

Welcome to the forum.
You want replace "MATHS" in a cell but with what text ? Or you simply want to show blank ("") in place of it ?

Regards,
DILIPandey

<click on below 'star' if this helps>

Not sure if this is what you want, but give it a try...

=IF(ISERROR(VLOOKUP("BA101",'SHEET 1'!$C$3:$C$52,1,FALSE)),"","MATHS")

Hi ade2tay,

Try using below formula:-

Formula:

Please Login or Register  to view this content.

See attached:- question.xls

regards,
DILIPandey

<click on below 'star' if this helps>

if you mean code tags in here, that only applies if you post VBA/macro coding

if thats not what you meant, perhaps you could explain more?

Originally Posted by ade2tay

Thanks for your help FDibbins. But I'm not sure whether I'm doing correctly with the code tags. I don't quite get it.

I was referring to your question regarding code tags - you only need to use those in here IF you are posting VBA code, otherwise you dont need top bother about them

lol thats ok, if you dont ask, you wont know...so in future, ask away if there is anything you dont understand, or need more explanation

and thanks for the rep

Here's another one. What's the formula if I want all the texts from C3:C52 in SHEET 1 to automatically appear in cell C29 (in SHEET 2)? Please refer previous attachment. TQ.