Oh nice, you saw through my initial mistake! This is great and is so close to what I need. It's filling in column 6 when it matches a pre-filled column 3, but it isn't doing the initial "scan in." For example, if sheet 1 is empty and I enter a 4 on sheet 2, I need it to fill out out column 3 on sheet 1 with that unmatched 4 on the next "empty" row. Does that make sense? This is extremely helpful, thank you for your help so far!