课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Categorizing bonuses with VLOOKUP

Categorizing bonuses with VLOOKUP - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Categorizing bonuses with VLOOKUP

“

- [Instructor] Let's categorize these bonuses using a VLOOKUP and an approximate match. Now, one thing with VLOOKUP that's not like XLOOKUP, When we do an approximate match, this count has to be sorted ascending. We also need a zero because anything lower than this 400 in this example is going to bomb out as an error. So, anything from zero to 399 gets no bonus, and we have to sort this ascending data. Sort, beautiful. Now, VLOOKUP time equals VLOOKUP. Double click. Look up what? Look up this count comma table array. We need to highlight both of these columns. Comma, column index number. We want to retrieve the second column's data for the two right there. Comma, approximate match. We want true. Put in a one or we could type true. Close parentheses and enter. And let's verify. Dory 904. Yes, that's 850 or above and earns $1,200 as a bonus. Hank and 312, that's between zero and 399, no bonus. But now what if…

内容