View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJSloss AJSloss is offline
external usenet poster
 
Posts: 13
Default 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))