FIRST, no. If you're searching for an exact match (4th parameter of False),
it doesn't matter what order the array is in. But if it needs to be in order
(4th parameter True), and you want to search in reverse, you would need to
sort the array first.

SECOND, not with Vlookup, but Index/Match can be used as an alternative. For
example:
=INDEX(A:A,MATCH("Value",C:C,0))
will search column C and return the corresponding row entry in column A.

Regards,
Fred.

"Blue Max" wrote in message
...
Two questions regarding the lookup functions as follows:

FIRST, is there any way to configure Lookup, Hlookup, Vlookup, or Match so
that the array will be searched from end to beginning (reverse order)
rather than from beginning to end?

SECOND, is there a way to configure a lookup so that the user can search
for the criteria in something other than the first row or first column of
a range? For example, could the user lookup a value in the third row and
return the associated value in the first row?

Thank you for any help with these questions.