Maybe =index()

or natural language formulas (I don't use these)

for =vlookup() and =index(match()), you could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html



hamma_thrower wrote:

=(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.

--

Dave Peterson