Your problem is not clear...

How will you know who is the owner or the name of the country for a given
magazine?

Do you have Magazine name in Col X, Owner in Y and country in Z?
If yes then why are you entering the name in Col X again?

Looks like you need to use VLOOKUP...

"Gerry1234567" wrote:

Hi, I have 3 columns of data.
Column x = a list of 130 magazines.
Column y = a list of the 45 media owners that own the 130 magazines.
Column z = a list of the 26 countries that the media owners are located in.
Ideally, I would like Excel 2007 to automatically complete Columns y and z
for me with the correct media owner and country when I enter the magazine
name in column x.
I have tried the IF function but I can only seem to be able to automate the
process for 1 magazine.
Can anyone help please ? !!
Many thanks in advance for a solution.