Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.  The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting.  The overall concept of writing a Nested IF is ... Continue Reading >>
As we get close to the end of the year, one of the things I always make sure to check before January is my overall tax liability.  From a financial perspective, my preference is to owe the government a little bit of money.  If at the end of the year, the government owes me a ... 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 >>
When writing a series of VLOOKUP formulas, one of the annoying things is having to see the "#N/A" error after Excel has determined a lookup value is not available.  While we don't want to show any values when they are truly unavailable, from a visual design perspective, it's sometimes better just to show a blank space ... Continue Reading >>
One of the most annoying things to have to do in Excel is writing a Nested IF statement.  For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for.  The most common usage of this formula is to assign ... Continue Reading >>
When I started rusinfomos.ru, I never really gave much thought to Excel's broader web community, which I was implicitly joining.  At the time, I was really just posting Excel tips and tricks because I thought they were interesting and would be useful to fellow MBA students.  While my engagement and capacity to contribute to ... Continue Reading >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... 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 >>

Related pages

excel vlookup pdfexcel compare columns for differencescynthia cheung dentistexcel modeling best practiceslearning vlookupdistribution curve excelvlookup hlookup pivot table tutorialbuild a histogramexcel filter using formulaexcel advanced tricksarea charts in excelhow to combine column in excelvlookup arrayvlookup formula in excel 2007how to show leading zeros in excelwhat is a vlookup tablehow to apply vlookup formula in excelexcel multiple if and statementsmicrosoft excel 2007 vlookuphow to remove duplicate valuesdownloading microsoft excel 2007 for freewebmail.ucla.edumatching data in two columns in excelsample p&l excelchart templates in excelcorrect symbol in excelhow to shade on excelmaking histograms in excel 2010how to calculate bin width in histogramcreate vlookup excel 2010excel compare rowshow to delete specific rows in excelprimo pdf softwarehow to randomize a list in excelcumulative total excelcommon excel shortcutsexcel input formulalookup exact matchhow to sort duplicates in excelhow to add a chart title in excel 2010short cut keys excelputting formulas in excelucla anderson mba tuitionrandom code generator excelwingdings checkboxvlookup formattingmost useful formulas in excelexample of hlookupexcel v lookupshow to write vlookup formula in excelexcel formulas lookup and referenceexcel charts templatesrandomizer in excelrandom list of names generatorexcell vlookuptornado chart excelhow to create macros in excelexcel formula sheettoo many cell formats excel 2010 fixhlookup function in excelipod packagingcountif greater thanvlookup shortcut keyhow to build an excel spreadsheethow to reduce rows in excelcountif matchexcel 2010 column headersrandom name chooser generatorbin range in excellookup values in excelhow to plot a distribution curve in excelvlookup excel 2007 exampleexcel countif criteria