vlookup_庆祝VLOOKUP周

vlookup

Over at Chandoo's Excel blog, he's celebrating VLOOKUP week, with helpful posts like VLOOKUP Formulas Go Wild. Who knew an Excel formula could go wild?

在Chandoo的Excel博客上，他正在庆祝VLOOKUP一周，并发布了诸如VLOOKUP Formulas Go Wild之类的有用信息。 谁知道Excel公式会变得疯狂？

I've seen many workbooks where things have run amok, but fortunately, Chandoo's examples are much better behaved.

我看过很多工作簿，情况还算不错，但是幸运的是，Chandoo的例子表现得更好。

You don't need any special equipment or fancy telescopes to do a lookup in Excel -- you just need a simple formula. Chandoo explains how to use the VLOOKUP function, and overcome its few shortcomings with other functions, like INDEX and MATCH.

您无需任何特殊设备或高档望远镜即可在Excel中进行查找-您只需要一个简单的公式即可。 Chandoo解释了如何使用VLOOKUP功能，并克服了INDEX和MATCH等其他功能的一些缺点。

观看VLOOKUP视频 (Watch the VLOOKUP Videos)

I'm a big fan of VLOOKUP too, and have made several Excel VLOOKUP videos that show you how to use the function in different scenarios.

我也是VLOOKUP的忠实拥护者 ，并且制作了一些Excel VLOOKUP视频 ，向您展示了如何在不同情况下使用该功能。

For example, here's a video that shows you how to use the Excel MATCH function within a VLOOKUP formula, to make it more flexible.

例如，下面的视频向您展示如何在VLOOKUP公式中使用Excel MATCH函数 ，以使其更加灵活。

演示地址

The next video show you how to use VLOOKUP to change a student's numeric score into a letter grade, by using the Approximate Match option.

下一个视频向您展示如何使用VLOOKUP通过“近似匹配”选项将学生的数字分数更改为字母等级。

演示地址

You can head over to the Contextures website, and watch the rest of my Excel VLOOKUP videos, to see a few more examples of how to use it.

您可以转到Contextures网站，并观看我的其他Excel VLOOKUP视频 ，以查看更多如何使用它的示例。

庆祝VLOOKUP周末 (Celebrate VLOOKUP Weekend)

With all this information on VLOOKUP to read and watch, you won't have to worry about planning any other weekend activities.

通过VLOOKUP上的所有这些信息可以阅读和观看，您不必担心计划其他周末活动。

Chandoo's VLOOKUP Week might end today, but you can continue celebrating, by creating your own VLOOKUP Weekend. Have fun! ____________

Chandoo的VLOOKUP周可能会在今天结束，但是您可以通过创建自己的VLOOKUP周来继续庆祝。 玩得开心！ ____________

翻译自: https://contexturesblog.com/archives/2010/11/05/celebrating-vlookup-week/

vlookup