Try this:

=INDEX(sked,MATCH(D1,INDEX(sked,,2),0),1)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"AJSloss" wrote in message
...
I am trying to use a function that will read a table in reverse (from the
right column to the left column) and so far I have this:

-table range is named "sked" and goes from a1:b5
-cell d1 is the value I want looked up

=index(a1:a5, match(d1, b1:b5, 0))

that works perfectly, however, is there a way to to use "sked" in that
formula so that it would look something like:

=index(1st column of "sked", match(d1, 2nd column of "sked", 0))