Auto-updating top-list.
Landanan,
Use a vlookup. First, you will have to put in a hidden column to the
right of the Score column (i.e. in column C). Make the cells = to the
Name Column (i.e. Column A). In your Top 5 Name Table in Cell A15,
type =vlookup(B15,B:C,2,FALSE). Drag the formula down for the other
four cells. Here is what the formula is doing:
1. B15 is the value you want to find.
2. B:C is the address of the table where the data is found (the
information you are looking (i.e. the value of B15) must be in the
leftmost column of the referenced table, hence the hidden column and
using the table in B:C, instead of using the table in A:B. Obviously,
you could also move the Score data from Column B to column A then
reference the table in A:B, rather than creating Column C and hiding
it.
3. 2 is the column within the table that contains the data you want
returned (i.e. the Name associated to the Score); the number is
relative to the leftmost column (i.e. since we start with Column B and
want Column C data returned, we want the 2nd column's data, but if we
started with Column A and want Column C data returned, we would want
the 3rd column's data.)
4. FALSE is optional, BUT it prevents the formula from returning a
partial match. For a partial match you can skip this part of the
formula, or you can type TRUE.
I hope this helps.
Jan
|