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.