This is exactly what I need if the reference column and the data are in
adjacent columns. Is it possible to do this if the reference data is in
Column A and the data I’m trying to capture are not adjacent to each
other such as column Q?


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=492759