developerWorks

AIX and UNIX
Information Mgmt
Lotus
	New to Lotus
	Products
	How to buy
	Downloads
	Live demos
	Technical library
	Training
	Support
	Forums & community
	Events
Rational
Tivoli
WebSphere

Java™ technology
Linux
Open source
SOA and Web services
Web development
XML

My developerWorks
About dW
Submit content
Feedback

developerWorks > Lotus > Forums & community > Lotus SmartSuite Forum

Lotus SmartSuite Forum

Assistance with @INDEX@MATCH formula

Assistance with @INDEX@MATCH formula
Posted by Jefferson Davis on 20.Apr.09 at 04:09 PM using a Web browser
Category: 1-2-3

Release: All Releases

Platform: All Platforms

Good afternoon all,

I am attempting to use the below formula;

@INDEX($3_PATTERNS,0,@MATCH($C17#AND#$D17#AND#$E17,$3_PATTERNS,0))

The problem is that I am attempting to match the contents of the 3 cells shown below with 1 row in a Range named 3_PATTERNS. I entered "9" in cell "C", "8' in cell "D", and "1" in cell "D" (as shown below).

Columns C D E

Row #17 9 8 1

Below is parts of the Range named "3_PATTERNS that I'm attempting to match;

A B C D E

Pattern
Number P1 P2 P3

1 = 0 0 0
2 = 0 0 1
3 = 0 0 2
4 = 0 0 3
5 = 0 0 4
6 = 0 0 5
7 = 0 0 6
(continues thru)
982 = 9 8 1
(ends with)
998 = 9 9 7
999 = 9 9 8
1,000= 9 9 9

The answer that the above formula is giving me is "1" where the correct answer is "982".

Would someone please tell me what I need to do to get this formula working correctly?

Thanks ahead of time for any help with this.

Return to top

Assistance with @INDEX@MATCH formul... (Jefferson Davis... 20.Apr.09)

. . Use @DGET (Russ Bartoli 20.Apr.09)

. . . . RE: Use @DGET (Jefferson Davis... 21.Apr.09)

. . . . @DGET -Simple? (Jefferson Davis... 22.Apr.09)

. . . . . . RE: @DGET -Simple? (Russ Bartoli 24.Apr.09)

. . . . . . . . RE: @DGET -Simple? (Jefferson Davis... 5.May.09)

Document options

Print this page

Search this forum

Forum views and search

	Date (threaded)
	Date (flat)
	With excerpt
	Author
	Category
	Platform
	Release
	Advanced search

	Sign in
	Forgot your password?
	Forgot your user name?
	Create new registration

RSS feeds

	All forum posts RSS
	All main topics RSS
	More Lotus RSS feeds

Resources

	Forum use and etiquette
	Native Notes Access
	Web site Feedback

Lotus Support

	IBM Support Portal - Lotus software
	Lotus Support documents
	Lotus support by product
	Lotus support downloads
	Lotus support RSS feeds

Wikis

	IBM Composite Applications
	IBM Mashup Center
	IBM Connections
	IBM Docs
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud for Social Business
	IBM Web Experience Factory
	Lotus Domino
	Lotus Domino Designer
	Lotus Expeditor
	Lotus Foundations
	Lotus iNotes
	Lotus Instructor Community Courseware
	Lotus Notes
	Lotus Notes & Domino Application Development
	Lotus Notes Traveler
	Lotus Protector
	Lotus Quickr
	Lotus Symphony
	IBM Web Content Manager
	WebSphere Portal

Lotus Forums

	Notes/Domino 9.0
	Notes/Domino 8.5 + Traveler
	Notes/Domino XPages development forum
	Notes/Domino 8
	Notes/Domino 6 and 7
	Notes/Domino 4 and 5
	IBM Connections
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud Notes
	IBM SmartCloud Meetings
	IBM Web Content Manager
	Lotus Domino Document Manager
	Lotus e-learning
	Lotus Enterprise Integration
	Lotus Expeditor
	Lotus Protector
	Lotus Quickr
	Lotus SmartSuite
	Lotus Symphony
	Lotus Symphony Developer Toolkit Support
	Lotus Workflow