Function with unlimited range inputs

[adamsdr3]

I'm sure there is a way to do this, I just haven't figured it out yet...

I need a function that is basically a combination of vlookup and sum that doesn't have to have a specific number of inputs. For Example;

TotalLength(a, b, c, d....., table array, column index value)

The result would be the sum of the corresponding table values for a, b, c and d. suggestions?

[xlnitwit]

Hi,

Here is one way with a UDF

Please Login or Register  to view this content.

I assumed you wanted an exact match.

[adamsdr3]

That's perfect! thanks!