There is no named function as such. The space character works as
the intersection operator. E.g,
=(B1:B10 A4:H4)
will return the intersection of B1:B10 and A4:H4, or cell B4.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"hamma_thrower" wrote in message
oups.com...
=(some column array) (some row array)
= the intersection of the two arrays.
I need more information on this; I just need the name to search
for it.
I have many 4x4 tables from which i need to get one value from,
both
vars could be called independent of each other.