# Excel - IF Function Problem - Expert Solution

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

I would like to find a value in another worksheet... and if it is there, place a word in a near cell
Solved by K. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/02/2018 - 08:00
Hello, welcome to got it pro
User 05/02/2018 - 08:01
hello
Excelchat Expert 05/02/2018 - 08:01
Let me know your query, plz
User 05/02/2018 - 08:01
what do you mean
Excelchat Expert 05/02/2018 - 08:01
i meant that ask your question please
User 05/02/2018 - 08:02
for example.... if the number 552 is in a cell, I would like to be able to see if this value is present in another worksheet... if it is, then place a label in another cell
Excelchat Expert 05/02/2018 - 08:03
Would you hae any workbook
User 05/02/2018 - 08:03
i would like to not share the data i have if possible
Excelchat Expert 05/02/2018 - 08:04
552 anywhere in a sheet or in a particular column
User 05/02/2018 - 08:04
column
Excelchat Expert 05/02/2018 - 08:04
it is easy for me to help you.
User 05/02/2018 - 08:04
ok
Excelchat Expert 05/02/2018 - 08:05
Kindly send me your book
User 05/02/2018 - 08:05
can we make a small example on the spreadsheet on this screen?
Excelchat Expert 05/02/2018 - 08:06
We can but, may be i didn't satisfy you in a manner you need
User 05/02/2018 - 08:06
i would like to try it this way.... I will make a small example.
Excelchat Expert 05/02/2018 - 08:07
your data will be safe, and justused for your solution, nothing else
Excelchat Expert 05/02/2018 - 08:07
ok right
User 05/02/2018 - 08:08
so for example.... i would like to know if the number "1" is shown on sheet 2 in that column....if it is, type "yes" in the empty cell next to "1" on sheet 1
Excelchat Expert 05/02/2018 - 08:08
ok
Excelchat Expert 05/02/2018 - 08:09
Give me some time
User 05/02/2018 - 08:09
ok
Excelchat Expert 05/02/2018 - 08:12
hy
User 05/02/2018 - 08:13
?
User 05/02/2018 - 08:16
are you there?
Excelchat Expert 05/02/2018 - 08:16
yes
User 05/02/2018 - 08:16
do you have an idea what I can do?
Excelchat Expert 05/02/2018 - 08:17
=IFERROR(IF(LOOKUP(Sheet2!A2,Sheet1!\$A:\$A)=A2,"YES",""),"")
Excelchat Expert 05/02/2018 - 08:17
copy this formula
Excelchat Expert 05/02/2018 - 08:17
and paste in cell b2 on second sheet
Excelchat Expert 05/02/2018 - 08:17
and then drag it to the end of your sheet
User 05/02/2018 - 08:18
so in this case.... you are looking back to sheet 1...
Excelchat Expert 05/02/2018 - 08:19
yes it looks back in column 1 of sheet 1, and if data exists there, it gives yes in column B
User 05/02/2018 - 08:20
ok i will try this...
User 05/02/2018 - 08:20
this helps me alot
Excelchat Expert 05/02/2018 - 08:20
Ok, thanks for contacting us

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.

## Click here to get your free Excelchat help session

Trusted by people who work at