VLOOKUP In Excel using Different Sheet
TO use V-lookup on different sheet and extract the data from different sheet please follow the mentioned step below.
V-LOOKUP is a vertical lookup formula in excel.
V-LOOKUP only looks from left to right. It always take a lookup reference from first column and give result from the column index selected.
Let's understand with the example.
In this example we need to extract the EMAIL ID From sheet 2 with the help of V-lookup.
STEP-1 Select THE CELL
STEP-2 =Vlookup( Lookup value , go to sheet 2 and select the table, provide the column index number where Email exist, 0 ( For exact match)
HIT ENTER.