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 - 07 Feb 2007 01:39 GMT
I'm not, but Harlan Grove is:
http://snipurl.com/19jai
or
http://groups.google.co.uk/group/microsoft.public.excel.worksheet.functions/brow
se_frm/thread/d7a1d40195d7fba9/3aa6ce81e91f8bf1?lnk=st&q=&rnum=1#3aa6ce81e91f8bf
1
> 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.

Signature
Dave Peterson
Monty - 07 Feb 2007 02:06 GMT
many thanks for responding and pointing me in right direction.
> 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 - 07 Feb 2007 02:09 GMT
Google is my friend. It can be your friend, too.
> many thanks for responding and pointing me in right direction.
>
> > 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.

Signature
Dave Peterson