Hi all, I am very novice with Excel and I have a problem that I don't
even know where to start with. I have two different Excel spreadsheets
that have data for different television programs. I need to go through
and compile all of the data into one sheet. The main issue is that
there are different variations in both of the spreadsheets in how the
television programs are named. I am looking to find a way to go
through one column of television names and find the match in the other
spreadsheet. Is there any function or method that I can use to do
this? Thanks for the help!