Vector lookup function
I'm currently trying to use the vector lookup function to return a value from another column. This works fine as long as the data is in ascending order. My problem is that the data column may not be sorted and is both ascending and descending. Maybe there's a better way, any help would be most appreciated. -- GregTh ------------------------------------------------------------------------ GregTh's Profile: http://www.excelforum.com/member.php...o&userid=16085 View this thread: http://www.excelforum.com/showthread...hreadid=275365 |
Have a look at other lookup functions like VLOOKUP(), MATCH() with INDEX(), etc., which allow you to set the match-type (range_lookup) to 0/FALSE. GregTh Wrote: I'm currently trying to use the vector lookup function to return a value from another column. This works fine as long as the data is in ascending order. My problem is that the data column may not be sorted and is both ascending and descending. Maybe there's a better way, any help would be most appreciated. -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=275365 |
All times are GMT +1. The time now is 02:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com