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.