Access to 130 free guest articles, discussions and more, just create your free OfficeUsers User ID:

Email address:

This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

See Related Articles

Article Abstract:

(Peter G. Aitken) Excel functions might seem a bit complex, but sometimes theres no avoiding a complicated formula to achieve the worksheet results you need. The ADDRESS() and INDIRECT() functions can provide you with flexibility that is not available any other way.

Read this article...

Related Articles - For Members.

	Lookup Tables
	Excel Functions: Count, CountIF, Sum and SumIF
	Excel COUNTIF Function for Two Conditions
	Excel IF statement - Nesting
	User Defined Functions in Excel
	Functions (By Category)
	Functions (by category)
	Exploring Excel's Functions: IF() Only!
	Excel user defined functions unlimited

Email to Friend // Discuss Article // Rate Article // Digg Article // Add to Del.icio.us // Add to Technorati

Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback

[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2008, Bits on the Wire, Inc.

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.