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.

1. V-LOOKUP is a vertical lookup formula in excel.
2. 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.
3. Let’s understand with the example.
4. In this example we need to extract the EMAIL ID From sheet 2 with the help of V-lookup.
5. STEP-1 Select THE CELL
6. 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)
7. HIT ENTER.

---

---

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit