I see that you've already received several suggestions if you are looking
for worksheet functions, so I won't repeat those.

In VBA (since this is the programming forum):

The Intersect (rng1,rng2,...) method "..returns a Range object that
represents the rectangular intersection of two or more ranges.."
The Union method would return the combination of two or more ranges.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"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.