The Favorited question happens to be "VLOOkUP" for me... on every interview this has been asked. The no of parameters (which is 4) and the last parameter (which is 0/1 or False and True). Next come the way to look up on the left which VLOOKUP can't do.. so INDEX and MATCH functions with OFFSET of course... Next would be advanced filters and then Pivot tables... everyone knowledgeable knows that VBA performs slow when compared to inbuilt Excel functions so questions on Macros have been few and far between...
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
