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