Database Theory

The Anchored COUNTIF is one of my favorite Excel formula tricks.   Using this technique provides a number of unique benefits, which make the formula worthwhile to learn.  While not as common as some of the more popular lookup formulas out there, being able to write an Anchored COUNTIF is still a great tool that can ... Continue Reading >>
The following is a guest post from Rishabh Bhandari, co-founder of Yoda Learning, a site that helps working professionals become faster and better in Microsoft office suite using high-quality video tutorials.  Before founding Yoda Learning, Rishabh worked with an Education-focused Private Equity fund in Mumbai, Continue Reading >>
If you're brand new to VLOOKUP or haven't used the formula in a while, the following quick reference guide is a great resource to have handy.  It's created by the folks at Microsoft, so you know it's legitimate. Reference Guide Summary The quick reference guide is in PDF format and is three pages long.  It goes into ... Continue Reading >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>
Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH Continue Reading >>
Learning the VLOOKUP formula is, for most people, the first step taken towards becoming an advanced Excel user.  For me, this milestone actually occurred in 2004 during an internship at Microsoft in the company's Commercial Operations Division.  One of the senior analysts showed me the ropes by teaching me the formula.  While Continue Reading >>
OFFSET MATCH MATCH is the final lookup combination I'll cover among the lookup formula options you have available to you in Excel.  Of all the different lookup options you have to do a two-way lookup, INDEX MATCH MATCH is still probably your best bet and the approach I would generally recommend.  However, OFFSET MATCH MATCH ... Continue Reading >>
VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and Continue Reading >>
INDEX MATCH Not Working?  The following article provides the most likely causes of your problems with using INDEX MATCH. If you're an advanced user of Excel, you've likely already made the switch from VLOOKUP to INDEX MATCH because of the several advantages that INDEX MATCH provides.  Within Excel, INDEX MATCH is one of the most Continue Reading >>
If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>

Related pages

what is a nested ifeasy vlookup tutorialcolumn index number excel3d stacked column chart excelexcel vba if cell containshow to stack graphs in excelhow to convert a formula to a value in excelmicrosoft excel tutorial torrentis there a way to remove duplicates in excelnested if in excel exampleucla graduate salarydifferent excel formulascompare 2 columns in excel using vlookupfancy excel templatesopen to buy excel spreadsheetfind duplicate lines onlineexcel functions tutorialwriting an if statement in excelmacro to delete duplicate rows in excelexcel duplicate sheethow to compare rows in excelhow to insert tick symbol in wordexcel delete all macrosexplain vlookup in excelexcel count duplicate valuesexcel in cell chartvba excel rangewhat is excel vlookupsample excel inventory spreadsheetshistogram tool excelwhat is a stacked column chartdelete columns in excelfinding duplicate values in excelcompare two columns in excel and find matchesexcel vlookup arrayvba lookup tableexcel vlookup example downloadvlookup 2 spreadsheetshlookup and vlookupexcel vba iferrorucla campus storesg&a calculationlookup function exampleiserror excelvllokup in excelhow to create a column chart in excel 2013blank excel formulaexcel nested functionexcel randomiserhow do you do a histogram in excelside by side stacked bar chart excel 2010decimal point in excelcountifs greater thanvba chart titlehistograms in excelrevenue projections in excelexcel look up functionif functions in excel 2013creating histograms in exceldedupe excelexcel offset formulamatch function in excel 2007how vlookup worksvlookup function tutorialhlookup functionhow to delete duplicate records in excel 2007definition of conditional formatting in excelexcel macro open excel filehow to convert numeric value in words in excel 2010excel stacked bar chart multiple seriesinteractive map uclaexcel graph labelsclassroom name pickercolumn offset vbaduplication in excelucla student health insurancestandard curve in excelhistogram microsoft excelucla average gmat