Gerry,

I've done this process similar to what you are describing.

First: Create three lists of the Magazines (alphabetical), two columns over,
Media Owners and two columns over enter the corresponding Country to the
correct owner. I like to name the ranges by selecting all the magazine list
and Naming the range Magazines. Do the same for Owners and Country

Then in column Y use a formula like this
=IF($A2="Vogue",LOOKUP(A2,Magazines,Owners),IF($A2 ="Elle",LOOKUP(A2,Magazines,Owners),IF($A2="Gol f
Digest",LOOKUP(A2,Magazines,Owners),IF($A2="MS",LO OKUP(A2,Magazines,Owners),IF($A2="Swimming",LOOKUP (A2,Magazines,Owners))))))

In Column Z use this
=IF($A2="Vogue",LOOKUP(B2,Owners,Country),IF($A2=" Elle",LOOKUP(B2,Owners,Country),IF($A2="Golf
Digest",LOOKUP(B2,Owners,Country),IF($A2="MS",LOOK UP(Magazines,Owners,Country),IF($A2="Swimming",LOO KUP(Magazines,Owners,Country))))))

You should have your results!
--
Thank you,

scrowley(AT)littleonline.com


"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.