Excel Tip 1: VLOOKUP to pull left column values

17/05/2017 0 0

Hi,
Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot lookup value column is not left most even though Vlookup is able to get the Product Name or Branch details

Note1: Choose function 1st argument contains flower brackets

Note2: If you change the column index number to 3 then it will populate branch details.

Hope it's a helpful tip. Will catch you in my next tip

0 Like 0 Dislike

Follow 0

Other Lessons for You

Shortcut of Excel for Selection

Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...

Shashank Maheshwari

1 0

Shortcut for adding big data or Columns in MS excel

1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 0

Difference between Find and Search Function in excel

In excel there are two functions which are taking same arguments and return type. SEARCH() --> Search a text within text, Case insensitive Example: Search("t","Management Team") and Search("T","Management...

Umasankar Natarajan

0 0

Be prepared to get trained--init

Before starting the training,students must be mentally prepared for acceptance of new knowledge. Students must attend training with open minded forgetting the position they are working.This will help...

Smartnub Softsolutions

0 0

HERE TODAY WE WILL USE THE SUMPRODUCT FUNCTION

A B C D E 1 SR.NO NAME SERIES _1 SERIES_2 TOTAL AMOUNT 2 1 VEERU 2 2 4 =sumproduct(D2,E2) 3 2 MAHIPAL 4 6 24 =sumproduct(D3,E3) 4 3 NIHSA 6 8 48 =sumproduct(D4,E4) 5 4 UMA 10 2 20 =sumproduct(D5,E5) 6 5 SHANKER 12 3 36 =sumproduct(D6,E6) 7 6 MAHESH 7 3 21 =sumproduct(D7,E7) 8 7 KAPIL 8 2 16 =sumproduct(D8,E8) ...

Saurabh Sharma

1 0

Find Advanced VBScript Training near you

Looking for Advanced VBScript Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Advanced VBScript Classes?

The best tutors for Advanced VBScript Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Advanced VBScript with the Best Tutors

The best Tutors for Advanced VBScript Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.