P
pauljen
Having trawled the groups trying to find something relevant, I've given
up.
I hope the following makes some kind of sense.
I have a table "Game by Game" which contains whether a particular
player played in a particular game. This data is already entered in an
Access Database, and I have transfered the data into a second sheet
"Access Lookup".
"Game by Game"
Bob Smith Dick Jones Fred Evans
Game 1
Game 2
Game 3
"Access LookuP"
Game 1 Bob Smith
Game 1 Fred Evans
Game 2 Fred Evans
Game 2 Dick Jones
Game 2 Bob Smith
Game 3 Fred Evans
The problem I now face is that I need to include some form of lookup in
each of the cells in "Game by Game", that looks in "Access Lookup",
takes the Player Name and Game Number , and finds if there is a match
in "Access Lookup". If there is a match (ie if Bob Smith played in
Game1)return TRUE in the Game1 Bob Smith cell in "Game by Game".
Hope this makes some sense! Thanks in advance.
Paul
up.
I hope the following makes some kind of sense.
I have a table "Game by Game" which contains whether a particular
player played in a particular game. This data is already entered in an
Access Database, and I have transfered the data into a second sheet
"Access Lookup".
"Game by Game"
Bob Smith Dick Jones Fred Evans
Game 1
Game 2
Game 3
"Access LookuP"
Game 1 Bob Smith
Game 1 Fred Evans
Game 2 Fred Evans
Game 2 Dick Jones
Game 2 Bob Smith
Game 3 Fred Evans
The problem I now face is that I need to include some form of lookup in
each of the cells in "Game by Game", that looks in "Access Lookup",
takes the Player Name and Game Number , and finds if there is a match
in "Access Lookup". If there is a match (ie if Bob Smith played in
Game1)return TRUE in the Game1 Bob Smith cell in "Game by Game".
Hope this makes some sense! Thanks in advance.
Paul