Help with changing of rank in a list

[Matthew Webb]

Hi, can anyone help?

I have a list of names and their rank last week...

1 john
2 mark
3 luke
4 matthew
5 david

and I have another sheet with this weeks rank and I want to show the
change...

1 +2 luke
2 +0 mark
3 +1 matthew
4 -3 john
5 +0 david

Lookup can't handle strings and even if in order can't handle two
strings starting with the same character... I can't find a solution.
HELP!

 

[Frank Kabel]

Hi Matt
if column A contains the rank and column B the name try the following
in C1 on your first sheet
=VLOOKUP(B1,'week_rank'!$A$1:$B$20,2,0)-A1

 

[Matthew Webb]

Hi Matt
if column A contains the rank and column B the name try the following
in C1 on your first sheet
=VLOOKUP(B1,'week_rank'!$A$1:$B$20,2,0)-A1

This doesn't work... It comes up '#N/A'.

 

[Frank Kabel]

Hi
sorry, my fault. Try
=INDEX('week_rank'!$A$1:$A$20,MATCH(B1,'week_rank'!$B$1:$B$20,0))-A1

 

[Matthew Webb]

Hi
sorry, my fault. Try
=INDEX('week_rank'!$A$1:$A$20,MATCH(B1,'week_rank'!$B$1:$B$20,0))-A1

Thanks Frank! That works perfectly, now I'm going to go and figure out
why.