ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Complicated lookup/match fuction (https://www.excelbanter.com/excel-worksheet-functions/49359-complicated-lookup-match-fuction.html)

keysersoze

Complicated lookup/match fuction
 

Azrael Wrote:
How about a little more detail?


Sorted! I split the functionality into 2 columns:
1/ to handle out-of-range numbers
2/ to perform a 'match' with different match_types depending on an
acending or decending range.


--
keysersoze


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com