How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- Office Version
- 2010
- Platform
- Windows
Hi…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
This is going to be long winded so please stick with it…
<o> </o>
I have a workbook for the 20 team English Premiership which is working. I want a workbook for the 20 team French League so I use “save as” in my English Premiership workbook and create the French book.
<o> </o>
I basically then change the 20 team names to French teams and change the club badges for each team… I’ve been doing this for a while, obviously as I develop my workbooks and nothing has gone wrong…
<o> </o>
Today it has!!!
<o> </o>
It’s to do with when I select a fixture (i.e. team A v Team B)… their club badges should be displayed but for some reason incorrect badges are OCCASIONALLY being displayed. It’s not random, some selections display correctly, other selections ALWAYS display incorrectly (So I might select team A v team B and it will display correctly… when I select team G v team H then for some reason the new workbook has started displaying the badge for Team B)…
<o> </o>
As everything was correct prior to me saving I’m totally lost here…
<o> </o>
My formulas are:
<o> </o>
Home Team…
<o> </o>
My Picture is called PcHome which is defined as =INDIRECT("Badges!$B$"&MATCH(Played!$AS$10,List,2))
<o> </o>
Away Team
<o> </o>
My Picture is called PCAway which is defined as
=INDIRECT("Badges!$B$"&MATCH(Played!$AS$11,List,2))
<o> </o>
List is defined as =OFFSET(Badges!$A$1,,,COUNTA(Badges!$A:$A))
<o> </o>
A strange symptom of my problem is… Played!$AS$10 and Played!$AS$11 can be different teams YET, they SOMETIMES they display the same picture.
<o> </o>
Can anyone see my problem please… what is the “2” doing in my MATCH? Just in case, my team names are in Badges!A1:A20 and the club badges in Badges!B1:B20.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>This is going to be long winded so please stick with it…
<o
> </o>I have a workbook for the 20 team English Premiership which is working. I want a workbook for the 20 team French League so I use “save as” in my English Premiership workbook and create the French book.
<o
> </o>I basically then change the 20 team names to French teams and change the club badges for each team… I’ve been doing this for a while, obviously as I develop my workbooks and nothing has gone wrong…
<o
> </o>Today it has!!!
<o
> </o>It’s to do with when I select a fixture (i.e. team A v Team B)… their club badges should be displayed but for some reason incorrect badges are OCCASIONALLY being displayed. It’s not random, some selections display correctly, other selections ALWAYS display incorrectly (So I might select team A v team B and it will display correctly… when I select team G v team H then for some reason the new workbook has started displaying the badge for Team B)…
<o
> </o>As everything was correct prior to me saving I’m totally lost here…
<o
> </o>My formulas are:
<o
> </o>Home Team…
<o
> </o>My Picture is called PcHome which is defined as =INDIRECT("Badges!$B$"&MATCH(Played!$AS$10,List,2))
<o
> </o>Away Team
<o
> </o>My Picture is called PCAway which is defined as
=INDIRECT("Badges!$B$"&MATCH(Played!$AS$11,List,2))
<o
> </o>List is defined as =OFFSET(Badges!$A$1,,,COUNTA(Badges!$A:$A))
<o
> </o>A strange symptom of my problem is… Played!$AS$10 and Played!$AS$11 can be different teams YET, they SOMETIMES they display the same picture.
<o
> </o>Can anyone see my problem please… what is the “2” doing in my MATCH? Just in case, my team names are in Badges!A1:A20 and the club badges in Badges!B1:B20.
