LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default Indirect and Match functions

Take a look at

http://www.decisionmodels.com/optspeede.htm


In article ,
"Malcom Jazz" wrote:

I have used both the above functions in lieu of vlookup. I pickedup the
formula from this NG. Can someone explain where both the functions can be
used either individually and/or combining them. In which circumstances it can
be used and all such stuff? I have gone thru the help file but in vain.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow Excel Worksheet Functions 7 May 21st 23 07:42 PM
Using INDIRECT within functions Brian Excel Worksheet Functions 4 January 2nd 10 03:53 AM
How to use Indirect functions? Eric Excel Discussion (Misc queries) 3 November 12th 08 07:34 AM
row-indirect functions [email protected] Excel Discussion (Misc queries) 3 February 28th 06 11:01 PM
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... [email protected] Excel Worksheet Functions 2 April 6th 05 09:59 PM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"