Lotus function @XINDEX
 

Anyone familiar with the Lotus @INDEX function and the Excel equivelant, if
any? For those that may not be familiar, its in effect a combination of
vertical and horizontal lookups in one formula.

Lotus function @XINDEX
 

I'm not, but Harlan Grove is:
http://snipurl.com/19jai
or
http://groups.google.co.uk/group/mic...a6ce81e91f8bf1

Monty wrote:

Anyone familiar with the Lotus @INDEX function and the Excel equivelant, if
any? For those that may not be familiar, its in effect a combination of
vertical and horizontal lookups in one formula.

--

Dave Peterson

Lotus function @XINDEX
 

many thanks for responding and pointing me in right direction.

"Monty" wrote:

Anyone familiar with the Lotus @INDEX function and the Excel equivelant, if
any? For those that may not be familiar, its in effect a combination of
vertical and horizontal lookups in one formula.

Lotus function @XINDEX
 

Google is my friend. It can be your friend, too.

Monty wrote:

many thanks for responding and pointing me in right direction.

"Monty" wrote:

Anyone familiar with the Lotus @INDEX function and the Excel equivelant, if
any? For those that may not be familiar, its in effect a combination of
vertical and horizontal lookups in one formula.

--

Dave Peterson