How To Use Vlookup Function In Excel

 If We Want to lookup data Vertically from another sheet Then we use Vlookup V stands for vertical Lookup.

How To Use Vlookup Function In Excel:

Now we will see how to apply VLOOKUP in excel.Write formula in empty cell where we want data to be placed =Vlookup(A2,

then go to anther sheet which data we want to print vertically in front of

2 Select all row (CTRL+space) and Press (Shift+right arrow) to column which data we want to be placed in previous sheet column

3 It is at 2nd place then enter comma ( ,2,0) in Formula bar as shown below and Drag below.

The Desired Data Will Be Printed here,In The Same Way We Can use Hlookup for horizontally lookup values

Do CTRL+C and then Special Paste by Shortcut( ALT+H+V+V) to remove formula