Posts

Showing posts with the label how to avoid #NA in excel

Lookup Functions in Excel: Creating Error Free Workbooks

Image
OVERVIEW "How do I compare the items in these two lists and see which are missing" "How do I look up a value in list ONE and pick up a related value from list TWO" "How do I avoid my lookup formula displaying an ugly error when it can't find a match?" "What's the difference between VLOOKUP function in Excel and INDEX-MATCH?" "I've heard of VLOOKUP but what's HLOOKUP formula in Excel?" These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel. WHY SHOULD YOU ATTEND By attending this intermediate-to-advanced training you can take your Excel knowledge to the next level. It is aimed at users who want to learn about the Lookup functions in Excel. Although the training will be delivered using the latest ver...