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.