I am not sure which function to use - vlookup, countif, or match. Can
someone help?
File #1 - column A: list of values (values & # of rows change daily)
column T: blank
File #2 - column A: list of values (value & # of rows change daily)
If a value in File #1 column A is found anywhere in File #2 column A, I
would like to color the corresponding row in File #1 blue and put an X
in File #1 column T. The color is actually something that would be
nice but not required.
Thanks in advance for any help!!!
Lia
--
moremetrics
------------------------------------------------------------------------
moremetrics's Profile:
http://www.excelforum.com/member.php...o&userid=23537
View this thread:
http://www.excelforum.com/showthread...hreadid=381357