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