**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have 2 excel files.
I want to highlight the values in column A of Table 1 which appear in Column 1 of table 2.
Thanks for your help

Solved by S. H. in 43 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
15/08/2018 - 07:34

hi!

Excelchat Expert
15/08/2018 - 07:34

Hello!

User
15/08/2018 - 07:34

Im not sure if you got my question?

Excelchat Expert
15/08/2018 - 07:34

How can i help you today? :)

User
15/08/2018 - 07:34

alright I know i know how to do this but im going crazy so i give up

Excelchat Expert
15/08/2018 - 07:35

what i undestood is that you want to be able to identify the records from your first file that are as well on the second file

User
15/08/2018 - 07:35

Yes!

Excelchat Expert
15/08/2018 - 07:35

correct?

Excelchat Expert
15/08/2018 - 07:35

sure, i can help you with that

User
15/08/2018 - 07:35

loyalty card numbers

Excelchat Expert
15/08/2018 - 07:35

can you share with me your 2 files please?

User
15/08/2018 - 07:35

on this table on the right?

User
15/08/2018 - 07:36

or just as files

Excelchat Expert
15/08/2018 - 07:36

if you want you can send them as attachment

Excelchat Expert
15/08/2018 - 07:36

so i can work on them on faster

Excelchat Expert
15/08/2018 - 07:36

then i'll explain you what i did

User
15/08/2018 - 07:36

ok! give me just a second

User
15/08/2018 - 07:36

fantastic

User
15/08/2018 - 07:36

let me just merge my 3 e3xcel tables

Excelchat Expert
15/08/2018 - 07:36

okok!

User
15/08/2018 - 07:37

thanks won't be long

User
15/08/2018 - 07:37

sorry

Excelchat Expert
15/08/2018 - 07:37

it's ok, don't worry

User
15/08/2018 - 07:38

sheet 1

User
15/08/2018 - 07:39

is it sending you the file?

[Uploaded an Excel file]

User
15/08/2018 - 07:39

so on that file

Excelchat Expert
15/08/2018 - 07:39

yes

User
15/08/2018 - 07:39

i want to highlight all the numbers from file 2 column 1 that appear in the first file in column 1

User
15/08/2018 - 07:40

give me just a sec for the second one

Excelchat Expert
15/08/2018 - 07:40

okok

User
15/08/2018 - 07:42

[Uploaded an Excel file]

User
15/08/2018 - 07:42

there you go =)

Excelchat Expert
15/08/2018 - 07:42

on the first file that you send me

User
15/08/2018 - 07:42

yes

Excelchat Expert
15/08/2018 - 07:42

which sheet would it be? sheet 2?

User
15/08/2018 - 07:43

its actually from the second file

User
15/08/2018 - 07:43

but i can merge them on one if you want and resend it

User
15/08/2018 - 07:43

sorry i didnt think youd actually do i i thought you would just explain how to do it

Excelchat Expert
15/08/2018 - 07:43

i can do both

User
15/08/2018 - 07:43

SHEET 1

User
15/08/2018 - 07:43

sheet 2 was a test i was trying

Excelchat Expert
15/08/2018 - 07:43

for example

Excelchat Expert
15/08/2018 - 07:44

what i would do for this is

Excelchat Expert
15/08/2018 - 07:44

on the file that you want it to be marked

Excelchat Expert
15/08/2018 - 07:44

(file 2) right?

User
15/08/2018 - 07:45

let me merge them it will be a lot easier

Excelchat Expert
15/08/2018 - 07:45

okok

User
15/08/2018 - 07:46

[Uploaded an Excel file]

User
15/08/2018 - 07:46

youll notice on this file stuff is red in sheet 2 .. probably from my failed formula

Excelchat Expert
15/08/2018 - 07:47

ok, i'm dowloading it

User
15/08/2018 - 07:47

so i want to highlight in sheet 1 column 1 the values from column 1 in sheet 2 that appear in column 1 sheet 1

User
15/08/2018 - 07:47

do we just have 6 minutes left?

Excelchat Expert
15/08/2018 - 07:48

yes, but you can extend it

Excelchat Expert
15/08/2018 - 07:48

it will allow you to extend when timer hits 5-

Excelchat Expert
15/08/2018 - 07:49

ok, i'm working on it

User
15/08/2018 - 07:49

thanks

Excelchat Expert
15/08/2018 - 07:49

does it allow you to extend?

Excelchat Expert
15/08/2018 - 07:49

time*

User
15/08/2018 - 07:49

nope

User
15/08/2018 - 07:50

and i presume to extend i have to pay

User
15/08/2018 - 07:50

i dont have access to the company card

Excelchat Expert
15/08/2018 - 07:50

oh ok

User
15/08/2018 - 07:50

so we have 4 minutes lol

Excelchat Expert
15/08/2018 - 07:50

basically

Excelchat Expert
15/08/2018 - 07:50

what i would recommend you to do is this

User
15/08/2018 - 07:51

it allowed me to extend

Excelchat Expert
15/08/2018 - 07:51

perfect! time was extended!

Excelchat Expert
15/08/2018 - 07:51

i was a bit nervous haha

User
15/08/2018 - 07:51

hehe

User
15/08/2018 - 07:51

so was i

Excelchat Expert
15/08/2018 - 07:52

first i would do this, a vlookup on the final columns

User
15/08/2018 - 07:52

ok

Excelchat Expert
15/08/2018 - 07:52

then i would add a condittion formating for column b

User
15/08/2018 - 07:52

why on the final columns

User
15/08/2018 - 07:53

the only column i want is column A

User
15/08/2018 - 07:53

1

Excelchat Expert
15/08/2018 - 07:53

where i would do, while value on the e column is different than #N/A color them on yellow

User
15/08/2018 - 07:53

i want to know which clients on sheet2 appear on sheet 2 and highlight them in sheet 1

Excelchat Expert
15/08/2018 - 07:54

ok, let me do it on the file

User
15/08/2018 - 07:54

sorry i graduated 10 years ago

Excelchat Expert
15/08/2018 - 07:54

then i'll explain you what i did once i send it back to you

User
15/08/2018 - 07:54

lol

User
15/08/2018 - 07:54

ok

User
15/08/2018 - 07:54

thank you very much

User
15/08/2018 - 07:54

i do want to understand

Excelchat Expert
15/08/2018 - 07:55

i will search it by card# right?

User
15/08/2018 - 07:55

yeah exactly

User
15/08/2018 - 07:55

all by card number

Excelchat Expert
15/08/2018 - 07:55

which is what column in sheet 1?

Excelchat Expert
15/08/2018 - 07:55

VIP #
?

User
15/08/2018 - 07:56

Card / in sheet 2 or VIP in 1

User
15/08/2018 - 07:56

so column 2 sorry

Excelchat Expert
15/08/2018 - 07:56

ok, and you want me to mark it on sheet 1, correct?

User
15/08/2018 - 07:56

yes

Excelchat Expert
15/08/2018 - 07:56

ok

User
15/08/2018 - 07:56

highlight on sheet 1 the customers that appear in sheet 2

User
15/08/2018 - 07:56

by card number

User
15/08/2018 - 07:57

as u can notice i wanted to do an IF formula which is why i created the true or falso column

Excelchat Expert
15/08/2018 - 07:58

okok

User
15/08/2018 - 07:59

brb

Excelchat Expert
15/08/2018 - 07:59

just to be sure

Excelchat Expert
15/08/2018 - 07:59

this is on your sheet 2, right?

Excelchat Expert
15/08/2018 - 07:59

--->>>

User
15/08/2018 - 08:01

?

User
15/08/2018 - 08:01

whats on my sheet 2

Excelchat Expert
15/08/2018 - 08:01

what i copied on the excel sheet on the right

User
15/08/2018 - 08:01

i dont see anything

Excelchat Expert
15/08/2018 - 08:02

row 12 and below

User
15/08/2018 - 08:02

the excel on the right is blank

Excelchat Expert
15/08/2018 - 08:02

oh ok

User
15/08/2018 - 08:02

a ha

User
15/08/2018 - 08:03

now i see it

User
15/08/2018 - 08:03

thats sheet 2

Excelchat Expert
15/08/2018 - 08:04

okok

Excelchat Expert
15/08/2018 - 08:04

give me a second

User
15/08/2018 - 08:04

no prob you have 9 min 23 sec lol

Excelchat Expert
15/08/2018 - 08:08

I'm still with you give me a few minutes more

User
15/08/2018 - 08:08

no prob

User
15/08/2018 - 08:09

ms.brodeur@motointer.com is my email if ever this runs out of time.. although you probably can't do that which i understand

Excelchat Expert
15/08/2018 - 08:09

you can extend again, i believe

Excelchat Expert
15/08/2018 - 08:10

sadly, i cannot contact you outside the tool. We are not allowed to do that

User
15/08/2018 - 08:10

ok .. i juste have to leave work for my nieces swimming class which wont wait for me

User
15/08/2018 - 08:10

can i extend and you send me the file while im not there?

User
15/08/2018 - 08:10

or it will be gone by tomorrow

Excelchat Expert
15/08/2018 - 08:13

[Uploaded an Excel file]

Excelchat Expert
15/08/2018 - 08:13

Ok, please look attached file

User
15/08/2018 - 08:14

So all the names highlighted in yellow are the ones that appear on sheet 2

Excelchat Expert
15/08/2018 - 08:14

what i did is, on sheet 1 column x, i created a formula that will look for column B value into the sheet 2 Column A

User
15/08/2018 - 08:15

Vlookup

Excelchat Expert
15/08/2018 - 08:15

then i created a condition formatting in the name

Excelchat Expert
15/08/2018 - 08:15

all yellows are the ones found

Excelchat Expert
15/08/2018 - 08:15

correct

User
15/08/2018 - 08:15

YOU ARE THE BEST !

User
15/08/2018 - 08:15

are u in the states

Excelchat Expert
15/08/2018 - 08:15

does this work for you?

User
15/08/2018 - 08:15

absolutely

Excelchat Expert
15/08/2018 - 08:15

perfect!

Excelchat Expert
15/08/2018 - 08:15

glad i coud help you

Excelchat Expert
15/08/2018 - 08:16

is there anything else i can help you with?

User
15/08/2018 - 08:16

i really appreciate it

User
15/08/2018 - 08:16

no that is all

Excelchat Expert
15/08/2018 - 08:16

you're welcome! thank you very much for using the service

Excelchat Expert
15/08/2018 - 08:16

hope to be able to help you again!

User
15/08/2018 - 08:17

have a great evening! are you guys in Canada or the UST6

User
15/08/2018 - 08:17

US

User
15/08/2018 - 08:17

i have to run

User
15/08/2018 - 08:17

thanks

User
15/08/2018 - 08:17

again

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