Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
REVERSE VLOOKUP | Excel Discussion (Misc queries) | |||
Reverse VLOOKUP | Excel Discussion (Misc queries) | |||
Reverse VlookUp | Excel Discussion (Misc queries) | |||
reverse VLOOKUP | Excel Discussion (Misc queries) | |||
reverse vlookup | Excel Worksheet Functions |