tag:blogger.com,1999:blog-2509167754737584590.post7580232784723396100..comments2010-01-03T09:11:27.480+05:30Yogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2509167754737584590.post-14058860617778064502010-01-03T09:11:27.480+05:302010-01-03T09:11:27.480+05:30Hello Sam<br /><br />Wecome to my blog. Thanks for your suggestion.<br /><br />Regards//Yogesh GuptaYogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-36602473121077183452010-01-02T12:26:25.287+05:302010-01-02T12:26:25.287+05:30Never use VLOOKUP.<br />Use Match/Index<br /><br />=Index(RngToPick,Match(WhatToMatch,WhereToMatch,MatchType)<br /><br />In your ex<br /><br />=Index(O$2:O$10,MATCH($B13,$B$2:$B$10,0))<br />It has many advantages over VLOOKUPS..samhttp://www.blogger.com/profile/07061407238879983091noreply@blogger.com