"kevindmorgan" wrote:
Name your range in the second sheet. I named mine "thetable" in this example.

In my example, it gives the item in column 2, and the proper row for the value that is in cell
B2.
=INDEX(thetable,B2,2)

Kevin,

That worked perfectly. Thanks for the help.

Here's what I did - selected my table in "Sheet2", named it "appreciation",
then in "Sheet1", I referred to it as follows:

=INDEX(appreciation,C20,2)

This referenced the value of C20 on Sheet1 (say "10") and used that as the
Row Number in the Named Table "appreciation". In this case "2" is column "B"
- odd why we have to switch back to numerical references for column when it's
defined as alpha by default.

Thanks Kevin.