How To Find The Last Match In An Array Using LOOKUP In Excel
In this tutorial we are going to use the LOOKUP function to find the last match in an array and return the corresponding value from another column from that row.
Thanks to Mr. Excel, Bill Jelen, for this tip found in his book "Power Excel"! This book has hundreds of great solutions using Excel to common and unusual problems.
Do you need help with a formula or an Excel project?
You can send me an e-mail to [email protected]
Including a sample file is always helpful!
You can donate to my channel through any of the following:
PayPal:
https://paypal.me/ExcelBytes?locale.x...
Zelle or Venmo:
Send to [email protected]