Function help!

P

phil2006

If I have a list of nations with values assigned to them based on recent
sport results, is there any way I can add the value I wish to assign
from the results that I have on my second page? For example, Spain may
have played 5 games and I want to use macros to add the value of their
results from page 2 on to page 1. I just don't know how to assign the
value each time a team name appears.
Any help would be of great assistance,

Cheers,

Phil
 
R

robert111

assuming one cell for each team on sheet 2 contains your assigned valu
number, which updates as scores come in, just refer to those cells i
sheet 1. As games are played, the values on sheet 2 will change, an
sheet 1 will automatically update. I hope this is not fantasy football
:-
 
P

phil2006

Thanks, what I meant was about getting the results onto the value sheet
I need to work out how to put corresponding values onto differen
sheets. Essentially, every time the text 'Spain' occurs on the result
sheet I need it to add the value onto the initial sheet in the Spai
column.
Any ideas?

Thank
 
R

Roger Govier

Hi Phil

It sounds as though this for the Football World Cup starting on the 9th.
I think I would have each country listed in column A and have adjacent
columns representing each of the group games, quarters, semi's and
finals going across the page.

I assume your first sheet is set out in the form of the draw.
Then you just look up the country on the second sheet and use the game
number as the offset in the Vlookup table to obtain the result.
 
Top