Highline Excel 2013 Class Video 23: VLOOKUP and IFNA for Commissions

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video: VLOOKUP and IFNA for Commissions: VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the flat commission rate when there is no contractual rate.

[excelisfun]

This Highline Class is created so that the viewer watches it from video #1 and then go to end. So sometimes there will be content in later videos that assume that you have watched earlier videos. But no problem, go and watch 318 and it will all be good.

[excelisfun]

Video title:
Highline Excel 2013 Class Video 18
shows how to use IFERROR. In that video I compare IFNA and IFERROR and the old way with ISNA. Video #18 is a great video to learn about all three methods.

[excelisfun]

In video: Highline Excel 2013 Class Video 18, click the show more button and use the time hyperlink table of contents to jump to the sections you want. There is a sections for each method.

[excelisfun]

No. This series is about Excel 2013. You can use IFERROR instead. Watch video numbner 18 in this series - it shows IFERROR

[yahshuapenyelamatku]

Hi, I don't have Excel 2013, how can I accommodate the command ifna(...) in my Excel 2010 so that I can replace the #N/A result in excel vlookup function? Thanks a lot.

[ashrafbandi]

dear Mr.ExcelIsFun,

function IFNA not work on Excel 2007 ?

[excelisfun]

You should not use swear words in a class environment like this.

[excelisfun]

Video title:

Highline Excel 2013 Class Video 18

shows how to use IFERROR. In that video I compare IFNA and IFERROR and the old way with ISNA. Video #18 is a great video to learn about all three methods.