vlookup in reverse

[AJSloss]

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))

 

[RagDyeR]

Try this:

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

HTH,

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


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))

 

[Shane Devenshire]

If you have only 2 columm why not give them each a name. Using more INDEX
function than your first example is going to slow calculations down.

=index(Sked1st,match(d1, Sked2nd, 0))

 

[Ragdyer]

How can you measure the calc time difference for 2 columns and 5 rows?

OH, you say maybe there's really more then 5 rows.

Well, maybe there's also more then 2 columns.

Most OPs are not looking for a fish ... they're looking to learn how to
fish!<g>

 

[T. Valko]

Some people are only interested in jacking up their post count.