G
Guest
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.