Hi,
In a nutshell, I have a 3-column worksheet where I'm struggling with how to perform the correct vlookup.
Column A contains all sites sold over the last 5 years, column b contains the dates those sites were sold, and column c contains a list of sites where a complaint has been received. Columns A & C are in the same format in terms of layout etc.
I need to find out which sites sold in the last 5 years have had a caomplaint raised - how do I do this?
Thanks,
Bookmarks