Hi Guys

I have spent too much time on this and I am stuck. haha

I am trying to do a comparison between 2 workbooks. But then if it is a match, I want another column to be copied into the other workbook.

I will try and explain it:

In workbook 2, I want a formula in Column W that is something like:
IF this (Book 1, Sheet 1, Column C) = THAT (Book 2, Sheet 1, Column F) THEN (Book 1, Sheet 1, Column A) COPY into (Book 2, Sheet 1, Column W)

Please help this lost soul fix it.