Vlookup to compare difference between 2 different sheets

[greenhillchris]

Hello,

I am trying to use a vlookup to compare the difference between 2 different sheets.

In a workbook I have a master sheet and a data sheet, and each sheet has the same 3 columns A, B and C of data. The data sheet will be updated regularly and what I am looking to do is on the master sheet highlight the difference in column A in the data sheet.

Each cell in column A will either contain a Yes, No or be empty, when column A in the data sheet displays a yes only, I want the master sheet to recognise only this difference.

For example if in the data sheet A3 has a Yes entered but on the master sheet there is no yes in A3 then I want it to recognise the difference.

I have tried a Vlookup but it is also picking up the no and empty cells and displaying it as a difference on the master sheet. Is there a way I can I can just highlight the difference when the word is yes.

Hope this makes sense.

Thanks for any help you can give me

 

[AhoyNC]

Maybe something like this:

Mater Sheet

Book1
	A	B
1	no	No Match
2	yes
3		No Match
4	yes
5	no
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(ISNA(IF(Data!A1="yes",VLOOKUP(Data!A1,A1,1,0),"")),"No Match","")

Data Sheet

Book1
	A
1	yes
2	no
3	yes
4	yes
5	no
Data

 

[greenhillchris]

That works great, just what I was looking for.

Thanks so much

 

[AhoyNC]

You're welcome. Thanks for the feedback.