VLOOKUP help - I am at a loss here...

[Canadian_Newb]

http://www.mediafire.com/?a7vpcup4qhnotuf

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Please see my worksheet (mediafire link) for what I’m working with.
<o></o>
What it is that I am trying to accomplish is the following:

<o></o>

• On the SCORE SHEET, enter a name in column B, score accordingly (current numbers in there are arbitrary)
• The TOTAL result from SCORE SHEET are recorded to the appropriate user on the SCORE OVERVIEW sheet

<o></o>
Seems simple enough, yes?
<o></o>
I’m using this formula:
<o></o>
=VLOOKUP("USERNAME",'SCORE SHEET'!B7:K18,10)
<o></o>
What is actually happening though is:

<o></o>

• When name is entered in SCORE SHEET, the TOTAL is either recorded to the right user (according to name) or it is seemingly recorded to multiple users

<o></o>
For example, I put in B7 the username CAPTAINDIGITS – it records the correct info back to the SCORE OVERVIEW sheet. But when I input 0PTIMUSPRIME in cell B18, the results from there overwrite all other results, regardless of the formula on the SCORE OVERVIEW sheet indicating a specific user for the results…
<o></o>
I am at a complete loss here…can someone please help/advise what I’m doing wrong?
<o></o>
Any help would be greatly appreciated.
<o></o>
Thanks so much!
<o></o>

 

[Excelestial]

Your explanation is vague ...as it doesn't tell us the significance of B18 (which looks to be part of your lookup array). I did notice this, however...

=VLOOKUP("USERNAME",'SCORE SHEET'!B7:K18,10, FALSE)

 

[Canadian_Newb]

Thanks for the reply - B18 was simlpy just another cell to enter a name in the array to show what was happening.

But I cannot believe that I missed the FALSE command...I entered it into the forumla, tested multiple cells, and it's working!

Boy do I feel silly.... :S

Thanks so much!

 

[Excelestial]

lol...happy to help. Thanks for the feedback.