Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|