Is this possible?

  • Thread starter Thread starter Monte Comeau
  • Start date Start date
M

Monte Comeau

I have a sorted list of low scores from 1 to 5.

I derived these numbers from a larger list of over 100 using the SMALL,1
function. (Thanks to this ng for that!)

Is it possible to have the name associated with this number placed in an
adjacent cell?

Problem., I am now able to pick out the 5 lowest scores, but they are
useless without the name that is associated with them.

Another possible problem is the name is not adjacent to the cells with the
scores, but two columns over.


thanks
 
Monte,

Almost anything is possible with Excel.
What it sounds like you're looking to do is fairly simple.

You'll need to do a vlookup on your data table.

Example:
Let's say Sheet1!A1 has a score.
Your table (with all the scores) is in Sheet2!A1:C100

In Sheet1!B1 you could place the following formula:
=VLOOKUP(A1,Sheet2!A1:C100,3,False)

Basic construct is:
=VLOOKUP(what, where, index,T/F)
The what and where are pretty straightforward.
The index is how many columns over to the right you
want the value from (in your case, the 3rd column)
The True/False ...... True means the data is sorted
alphanumerically and you don't need an an exact match.
(just the one that's closest without being over)
False means the table doesn't have to be sorted and
you're looking for an exact match.

John
 
Back
Top