hi guys
i have an idea that i will be able to select a team in sheet1 cell a1 via a dropdownlist and also c1 giving a home and away team

all teams have there own unique number which i would be able to list them all

it would then look at c1 compare it against the list and use that number

then on sheet two

it would return the results

web address is http://www.soccerbase.com/head2.sd?t...42&team2id=154

arsenals number is 142
aston villa are 154

is there any way i could go about this easily?

im sure it can be done just need pushing the right way

thanks gents