Biff,

Going through the numbers, not only are there a few duplicates, but the
data is actually in more than one column. It just seems to get messier
as we go along. Can you please tell me how to work around that?

Thanks!
Holli



Biff wrote:
Try this:

This table is in the range A2:B7

Chicago, 50
New York, 23
San Francisco, 43
San Jose, 55
Baltimore, 14
Ann Arbor, 28

Enter this formula in D2:

=INDEX(A$2:A$7,MATCH(E2,B$2:B$7,0))

Enter this formula in E2:

=SMALL(B$2:B$7,ROWS($1:1))

Select both D2 and E2 and copy down 5 rows.

Based on your sample data there are no duplicate numbers. If there are this
will be more complicated. Post back if that's the case.

Biff

"HBuck" wrote in message
ups.com...
Hello all,

I'm having a bit of a problem that I hope that someone can help me
with. Here's my sample data range:
City, Rate
Chicago, 50
New York, 23
San Francisco, 43
San Jose, 55
Baltimore, 14
Ann Arbor, 28

I want to populate a two-column, five row table with the city and rate.
I've used the SMALL function in the rate column to include the five
lowest rates. My problem is, I'm able to retrieve the rates, but I
can't populate the first column with the City.

What I need is if column B=14, then A=Baltimore and such. Does anyone
have any ideas how I can set that up?

Holli - who hopes that was semi-coherent