Rick,

Is there any chance that you could adapt this to allow for multiple criteria/criteria ranges? Assuming my lookup table contains multiple columns by which I want to match my search criteria against, the only way I've been able to do this thus far is create a string in the first column of the lookup table concatenating all of my "search criteria" into a single string, and then searching for that string etc. Is there a way you could use a paramarray etc., to allow for a variable amount of multiple criteria and criteria ranges?

Thanks,