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
[…] we want to vlookup something in excel it should be in left to write order otherwise vlookup […]
[…] excel we use vlookup to seach data vertically from another sheet.If we have two sheets Lets say sheet1 & sheet 2 and […]