Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

XINDEX

0 views
Skip to first unread message

James

unread,
Aug 28, 2002, 11:23:03 PM8/28/02
to
Is there an excell equivalent to Lotus' XINDEX lookup
funtion i.e. a 3-d lookup function?

Andy Wiggins

unread,
Aug 29, 2002, 3:51:34 AM8/29/02
to
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/xindexvba.zip

It's in the "Excel for Lotus 123 Users" section on page:
http://www.bygsoftware.com/examples/examples.htm

In Excel there is no direct equivalent for Lotus 123's XINDEX function.
This workbook shows two Excel formula constructions that achieve the same
result.

The first example uses two additional inputs.
It uses the Excel functions: INDEX and MATCH
The second example uses the same inputs as the Lotus XINDEX function.
It uses the Excel functions: INDEX, MATCH and OFFSET.

There are also two additional pieces of VBA showing how to use this in code
and capture an error condition.

The code is open and commented.

Regards
Andy Wiggins FCCA
www.BygSoftware.com
Home of "Byg Tools for VBA" and "The Excel Auditor"

"James" <james...@iesg.com> wrote in message
news:a83b01c24f0b$623796c0$b1e62ecf@tkmsftngxa04...

0 new messages