<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener("load", function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <iframe src="http://www.blogger.com/navbar.g?targetBlogID=28182552&amp;blogName=:xL-tips&amp;publishMode=PUBLISH_MODE_BLOGSPOT&amp;navbarType=SILVER&amp;layoutType=CLASSIC&amp;searchRoot=http://xl-tips.blogspot.com/search&amp;blogLocale=en_US&amp;homepageUrl=http://xl-tips.blogspot.com/&amp;vt=-7072926953029533487" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" height="30px" width="100%" id="navbar-iframe" allowtransparency="true" title="Blogger Navigation and Search"></iframe> <div></div>






16 May 2006

2D lookup

Category: Multiple Formulas
Level: Intermediate

Are u ever use vlookup or hlookup formula?
These formulas just can search a cell with a criteria. Then what should we do if we have 2 criterias?

It's simple u can use this formula
=INDEX(table, MATCH(column criteria, first column of table, 0),MATCH(row criteria, first row of table, 0))

For example, I have a table. First row is subject name and first column is student name. I want to know what is Udin's rate in Basic Mathematic subject.



The formula in C11 is:
=INDEX(B2:E8,MATCH(B11,B2:B8,0),MATCH(C10,B2:E2,0))

posted by F-Xtudent at 11:21 AM

0 Comments:

Post a Comment

<< Home