Hi Tom.

Thanks for your help. I tried using that formula and something OD
happened. It should have pulled the data from cell I8 to paste, thi
cell matched the criteria of if "X"&"Y". Instead, it pulled the dat
from cell I13 that did match "X" but not "Y". At first glance ther
doesn't seem to be any reason why that data should have been pulled.

Thoughts?

THANKS

--
Message posted from http://www.ExcelForum.com