LOOKUP formula not working.

[Asw091]

[FONT=&quot][FONT=&quot]Hi guys,[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I hope you can help.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I have a leaderboard based on certain scores. It update automatically and puts people’s names in order based on their scores, but doesn’t show their scores next to their name.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I’ve tried a simple lookup formula but it doesn’t appear to be working.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]Cells S4:S11 has the names and cells T4T:T11 has the scores (scores are a sum of the previous cells).[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]In AC4:AC11 shows the names in winning order.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I’ve input the formula =LOOKUP(AC4,S4:S11,T4:T11) however this doesn’t return the relevant score.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I’ve tried this on many other sheets and even created a manual scoreboard below on which it works.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]Could anyone help me understand why it won’t work on the automated one?[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]Do he names have to be put in manually so it’s reading text and not an output of a formula?[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]Any help would be greatly appreciated.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]Thanks.[/FONT][/FONT]

 

[Marcelo Branco]

LOOKUP requires the lookup_vector (S4:S11 in your case) in ascending order. I think you should use INDEX/MATCH.
Could you post a data sample along with expected results?

M.

 

[Asw091]

LOOKUP requires the lookup_vector (S4:S11 in your case) in ascending order. I think you should use INDEX/MATCH.
Could you post a data sample along with expected results?

M.

Thanks mate, INDEX/MATCH worked a great.

 

[Marcelo Branco]

You are welcome.

M.

 

[Special-K99]

Or use VLOOKUP

=VLOOKUP(AC4,S4:T11,2,0)