A further update:

The design has moved on as I wasn't able to find a solution to use
VLOOKUP to count or sum multiple cells:

:) I've now created columns with the team name at the top of the
spreadsheet going left to right. Underneath each team I have listed
Week 1, Week 2 etc... going down the page, with alongside the result W,
D, or L. At the bottom I have used the COUNT function to sum the total
number of draws, wins or losses.

I'm now having a problem - and really shouldn't be - with a straight
forward IF statement. As LES offered earlier with his suggestion...:)
using the following should do/say this:

If range A12:A17 equals "TEAM NAME" then VLOOKUP L2 (which is the TEAM
NAME) in table array A12:B17 select the value in the second column and
return nothing if not found.

=IF(A12:A17="TEAM NAME",VLOOKUP($L$2,A12:B17,2,0),"")

However the result is always a blank cell, as it doesn't
appear to recognise the TEAM NAME.


--
kreatiff
------------------------------------------------------------------------
kreatiff's Profile: http://www.excelforum.com/member.php...o&userid=37732
View this thread: http://www.excelforum.com/showthread...hreadid=573223