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.