How to Use VLookup With Different Sheets on Excel. Excel's VLOOKUP function searches an array of cells for data you choose, returning data from the cell next to the one that it finds. For example ...

In this Windows 10 guide, we'll walk you through the steps to correctly write a basic VLOOKUP function with the desktop version of Microsoft Excel, whether you use the version of Office available ...

For example, if this corner cell of the array is E3, change the formula to:=VLOOKUP ("string", E3:G26, 2, FALSE) Replace "G26" with the address of the lower-right cell from the array Excel searches.