# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula to be located in a protected cell (A1) to search for text in A2 and if true copy to A3 or do nothing to A3 if false.
Solved by M. U. in 38 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 26/04/2018 - 05:27
Hi
User 26/04/2018 - 05:28
hello
Excelchat Expert 26/04/2018 - 05:28
Welcome to Got it Pro
Excelchat Expert 26/04/2018 - 05:28
Can you paste the sample data so that i can help you with the formula
Excelchat Expert 26/04/2018 - 05:29
which test to search?
Excelchat Expert 26/04/2018 - 05:29
text^
User 26/04/2018 - 05:30
Excelchat Expert 26/04/2018 - 05:32
User 26/04/2018 - 05:34
i need to have the formula in j2 (locked) to search for specific text in i2 (non-admit) and if true copy to c2 and do nothing if false
Excelchat Expert 26/04/2018 - 05:34
ok
Excelchat Expert 26/04/2018 - 05:35
but c2 has some value in it
User 26/04/2018 - 05:35
can it be replaced if true ?
Excelchat Expert 26/04/2018 - 05:36
where?
User 26/04/2018 - 05:37
if j2 is true i need it to replace what ever text is in C2
Excelchat Expert 26/04/2018 - 05:37
ohk
Excelchat Expert 26/04/2018 - 05:41
See now
Excelchat Expert 26/04/2018 - 05:41
The formula in J2
Excelchat Expert 26/04/2018 - 05:41
Hpope this helps
Excelchat Expert 26/04/2018 - 05:42
try puttin non admit in A2
Excelchat Expert 26/04/2018 - 05:42
or word which contains this
User 26/04/2018 - 05:42
the search needs to search J2
Excelchat Expert 26/04/2018 - 05:43
j2 has the formula
User 26/04/2018 - 05:43
ok this looks back words
Excelchat Expert 26/04/2018 - 05:43
User 26/04/2018 - 05:43
no not yet
Excelchat Expert 26/04/2018 - 05:43
back works as in?
Excelchat Expert 26/04/2018 - 05:44
what do you require
Excelchat Expert 26/04/2018 - 05:44
Excelchat Expert 26/04/2018 - 05:46
you there?
User 26/04/2018 - 05:46
i need the formula to be in J2 to search I2 for the word "non-admit" and if its true then copy I2 into C2 replace whatever is in C2
User 26/04/2018 - 05:46
or do nothing to C2 if false
Excelchat Expert 26/04/2018 - 05:47
in this case we need to put two formula
Excelchat Expert 26/04/2018 - 05:47
one in J2 and one in C2
Excelchat Expert 26/04/2018 - 05:47
but in c2 already there is some value
Excelchat Expert 26/04/2018 - 05:47
so we can create a column C2_New
Excelchat Expert 26/04/2018 - 05:48
where we can copy the value based condition
User 26/04/2018 - 05:48
C2 get overridden when importing data
Excelchat Expert 26/04/2018 - 05:48
then you might need to use macros
Excelchat Expert 26/04/2018 - 05:48
i am not a macro expert
Excelchat Expert 26/04/2018 - 05:48
but this can be done with formulas making a new column iof that helps you
User 26/04/2018 - 05:48
whats the 2 formula's ?
User 26/04/2018 - 05:48
yes that would help
Excelchat Expert 26/04/2018 - 05:49
see now
Excelchat Expert 26/04/2018 - 05:50
When I2 is there in A2 then j2 shows some value
User 26/04/2018 - 05:50
why is A2 being used ?
Excelchat Expert 26/04/2018 - 05:51
you wanted to search non-admit in A2?
User 26/04/2018 - 05:51
here, let me show
Excelchat Expert 26/04/2018 - 05:52
show
Excelchat Expert 26/04/2018 - 05:53
Are you there?
Excelchat Expert 26/04/2018 - 05:53
User 26/04/2018 - 05:53
yes one sec
Excelchat Expert 26/04/2018 - 05:58
See now
Excelchat Expert 26/04/2018 - 05:58
formula in E2
Excelchat Expert 26/04/2018 - 05:58
Excelchat Expert 26/04/2018 - 05:58
E2 will be over written
User 26/04/2018 - 05:59
can i have formula in a cell locked and display data ?
Excelchat Expert 26/04/2018 - 06:01
see now
Excelchat Expert 26/04/2018 - 06:01
in cell E2
User 26/04/2018 - 06:02
perfect
Excelchat Expert 26/04/2018 - 06:02
if there is no non-admit in k2 then e2 will display pending admit
Excelchat Expert 26/04/2018 - 06:02
Hope this helps you
Excelchat Expert 26/04/2018 - 06:02
Please do give good rating and reviews
Excelchat Expert 26/04/2018 - 06:02
It would really helps
User 26/04/2018 - 06:03
how do i lock the formula to enter data
Excelchat Expert 26/04/2018 - 06:04
Excelchat Expert 26/04/2018 - 06:04
https://support.office.com/en-us/article/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a
Excelchat Expert 26/04/2018 - 06:04
follow the steps that would help
User 26/04/2018 - 06:05
ok, thank you.
Excelchat Expert 26/04/2018 - 06:06
Welcome
Excelchat Expert 26/04/2018 - 06:06
Excelchat Expert 26/04/2018 - 06:06
It really helps
User 26/04/2018 - 06:06
i will.
Excelchat Expert 26/04/2018 - 06:06
Have a great day

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.