Need:Function help!

[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

[robert111]

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

[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 different sheets. Essentially, every time the text 'Spain' occurs on the results sheet I need it to add the value onto the initial sheet in the Spain column.
Any ideas?

Thanks

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

--
Regards

Roger Govier


"phil2006" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> phil2006
> ------------------------------------------------------------------------
> phil2006's Profile:
> http://www.excelforum.com/member.php...o&userid=35092
> View this thread:
> http://www.excelforum.com/showthread...hreadid=548543
>