**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

non-admit

Excelchat Expert
26/04/2018 - 05:32

can you explain your requirement please

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

Does it help you out?

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

Please let me know

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

Please tell

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

put non admit in k2

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

Please follow this for locking

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

Please do give good rating

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.*