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.
--
Malcom Jazz
Engineers spent all their lives knowing more and more about less and less till they know everything about nothing.