Lotus function @XINDEX

[Monty]

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]

I'm not, but Harlan Grove is:
http://snipurl.com/19jai
or
http://groups.google.co.uk/group/mi...e81e91f8bf1?lnk=st&q=&rnum=1#3aa6ce81e91f8bf1

 

[Monty]

many thanks for responding and pointing me in right direction.

 

[Dave Peterson]

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

many thanks for responding and pointing me in right direction.