Theoretically it does. Programming (and math) purists would tell you that a
function is not allowed to access anything that is not passed to the
function via arguments in the function call. And there are very good reasons
for requiring this.

I agree that is not of much use to you, as a user. But I don't see the
problem either.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Budman" wrote in message
...
I don't disagree with any of you, there's certainly other ways to do
lookups.
But it doesn't change my original comment....why require a table array? I
just don't think it belongs in the function.

Budman