So I need a UDF that is able to find values to the left and right of a found value and able to find the nth match of a value for a quality monitoring sheet I am making. This is what I have right now and I was wondering if there are any critiques or tips/tricks to make it more efficient (it is, however, already MUCH faster than using array functions).
The UDF must return a value error if nothing is found.

Please Login or Register  to view this content.
I'm somewhat of a novice at UDFs and macros so any tips/tricks would be super appreciated.
Thank you very much in advance,
Andrew Harris