Reverse VLookUp/ WLookUp
The LookUp formulas are very powerful tools for any kind of application. Often you are not only searching for the first corresponding value in an Excel sheet, but also for the last corresponding value in an Excel sheet. So reverse references would be very useful.
The Reverse VLookUp should therefore search from bottom to top in the matrix.
The Reverse WLookUp should therefore search from right to left in the matrix.