Applies ToExcel 2013

Important: Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor. This feature is only available if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.Link to try or buy Microsoft 365

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

An explanation of each of the function's arguments.

The arguments

  • H2 is the cell that contains the lookup value.

  • B3:F25 contains the lookup values (column B) and the corresponding data you want to find, always to the right of column B.

  • 3 is the column that you think contains the data you want to find. It is the third column over from B.

  • FALSE means you want an exact match.

Want more?

VLOOKUP function

Quick reference card: VLOOKUP refresher

Quick reference card: VLOOKUP troubleshooting tips

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.