How to Vlookup?

[mona4]

Hi,
I have a basic lookup which highlights various codes down the column if they do not match with worksheet 1. I need the codes to also highlight in worksheet 1 from where it matches them so i can compare the two, any ideas? i hope im being clear!

 

[texasalynn]

not very clear. Are you wanting to have some type of conditional format? COuld you give some examples of your data

Thanks . . . texasalynn

 

[mona4]

I have a list of company codes which are refreshed as the these can change now and again. In worksheet two i have the same codes with a vlookup column beside them
=IF(ISNA(VLOOKUP(E447,'S&P'!A:B,1,FALSE)),"No Match",VLOOKUP(E447,'S&P'!A:B,1,FALSE)).

Codes not matching highlight red so i can update them in worksheet 2. However the codes in worksheet 1 one do not highlight aswell. Secondly I cannot tell which comapnies codes have been erased from the list, so that i can add them to the exisitng list in worksheet 2.