HOW TO USE VLOOKUP IN EXCEL (BEST WAY TO USE)

Video ready, click here to close ×


1. VLOOKUP for workbook to other workbook?
2. Open the workbook you looking for the values then type =VLOOKUP select the lookup value in the cell, after that select table array from another workbook, And type the col index num (if that column num at 3 then you type 3) and last type 0 than hit enter. That’s it copy that cell to the below cells.
3. VLOOKUP for sheet to other sheet?
4. Open the workbook you looking for the values then type =VLOOKUP select the lookup value in the cell, after that select table array from another sheet, And type the col index num (if that column num at 3 then you type 3) and last type 0 than type the $ middle of the table array numbs so that that table array get standard. That’s it copy that cell to the below cells.
5. I hope it’s helpful to you.

FACEBOOK PAGE: http://sh.st/2Fmb5

GOOGLE+: http://sh.st/2FmHm

-~-~~-~~~-~~-~-
Please watch: “DIY projects Smartphone Projector (Tutorial) – How To Make Your Smartphone Image 20 Times Bigger”

Video ready, click here to close ×

-~-~~-~~~-~~-~-

source

Leave a Reply

Your email address will not be published. Required fields are marked *