Solution or alternative to Excel MATCH 255 character limit

I am not sure that there will be a terribly efficient way, either with formulas or VBA. If you can limit your range sizes, perhaps by creating Dynamic Named Ranges, you can limit the ranges to absolute min needed... then convert your formula to: =INDEX(My

www.ozgrid.com