Why do we use vloookup/hlookup, when lookup has all the features(i.e produces same result, with lesser complications) of vlookup/hlookup , and plus has more advantages, like the right to left functionality ? Is there any limitation to lookup, that is solved by vlookup/hlookup, which is why vlookup/hlookup may be used in certain places rather than lookup?