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

How to find values on another worksheet.

Find data on other worksheets

  • Add the name of the worksheet and an exclamation point to the table array argument, like so:

    =VLOOKUP(H2,Pages!B3:F25,3,FALSE)

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.