Formula Help
 

Hello,
i have set up a fantasy team within my football club depending on total
goals scored, the table at the top of my design shows all the players and the
goals scored. below is the fantasy team that player 1 made. is there a way of
returning the scores in c16 depending on the player that is listed in b16,
which refers to the main table scores, so it can quickly caculate that total.
thanks, lyndon.

Here is the file:

http://rapidshare.com/files/25304667...Team.xlsx.html

Formula Help
 

Hi
Try this in C16
=VLOOKUP(B16,$B$2:$C$12,2,FALSE)

to trap for error, this will return blanks if the name is not found in the
list
on the top table of your example
=IFERROR(VLOOKUP(B16,$B$2:$C$12,2,FALSE),"")


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"dc04wrightl" wrote:

Hello,
i have set up a fantasy team within my football club depending on total
goals scored, the table at the top of my design shows all the players and the
goals scored. below is the fantasy team that player 1 made. is there a way of
returning the scores in c16 depending on the player that is listed in b16,
which refers to the main table scores, so it can quickly caculate that total.
thanks, lyndon.

Here is the file:

http://rapidshare.com/files/25304667...Team.xlsx.html

Formula Help
 

Hi,
try
=sumproduct(--(B16=B2:B15),C2:C15)

"dc04wrightl" wrote:

Hello,
i have set up a fantasy team within my football club depending on total
goals scored, the table at the top of my design shows all the players and the
goals scored. below is the fantasy team that player 1 made. is there a way of
returning the scores in c16 depending on the player that is listed in b16,
which refers to the main table scores, so it can quickly caculate that total.
thanks, lyndon.

Here is the file:

http://rapidshare.com/files/25304667...Team.xlsx.html

Formula Help
 

Thank you both for your replies, both work :)

"Eduardo" wrote:

Hi,
try
=sumproduct(--(B16=B2:B15),C2:C15)

"dc04wrightl" wrote:

Hello,
i have set up a fantasy team within my football club depending on total
goals scored, the table at the top of my design shows all the players and the
goals scored. below is the fantasy team that player 1 made. is there a way of
returning the scores in c16 depending on the player that is listed in b16,
which refers to the main table scores, so it can quickly caculate that total.
thanks, lyndon.

Here is the file:

http://rapidshare.com/files/25304667...Team.xlsx.html