vlookup in reverse
 

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

vlookup in reverse
 

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

vlookup in reverse
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"AJSloss" wrote:

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

vlookup in reverse
 

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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Shane Devenshire" wrote in
message ...
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))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"AJSloss" wrote:

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

vlookup in reverse
 

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

--
Biff
Microsoft Excel MVP


"Ragdyer" wrote in message
...
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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Shane Devenshire" wrote in
message ...
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))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"AJSloss" wrote:

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