Tim Lovelock

• VLOOKUP
• IF
• ISERROR
• CONCATENATE
• YEAR
• MONTH
• WEEKNUM

My favorite function mashup is to combine IF, ISERROR, and VLOOKUP to return either a value from another table, or 0 (or blank, if you prefer). Here’s how to do it:

=IF(ISERROR(VLOOKUP([Std vlookup formula])),0,(VLOOKUP([Std vlookup formula])))

Here’s the logic: If the Vlookup returns an error (i.e., the value of the referenced cell does not exist in the lookup range), then return a value of Zero, else return the value found in the lookup range.

Why? It gets rid of those nasty “#N/A” errors.

Tags: CONCATENATE, Excel, formula, IF, ISERROR, MONTH, VLOOKUP, WEEKNUM, YEAR

Related posts

• There’s a reason fundamental skills are called “Fundamental” (1)
• Taking Responsibility for Materials Management on a Mature Program or Product (2)
• Simple MRP Model Using OFFSET Function in Excel (0)
• I can see a ton of uses in my day job for this: #Excel conditional drop-down lists (0)
• Dashboarding the program in #Excel well underway (0)