Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How we use vlook up statement?

tell me ans about it and also give examples

user-image
Question added by zeeshann zeb , Assistant Accounts Officer , sadiq group of companies
Date Posted: 2013/10/28
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

=vlookup(select the unique value from your datasheet(,) the go the sheet where the same valude needs to be found(,) then1(,)true or false)

Prasanth Prabhakaran
by Prasanth Prabhakaran , Accounts Manager , BRASSWORLD

Sort your reference list on the Unique index key which you want to lookup in the other list, ensure that unique values remain.

 

In you data list, enter Vlookup(cell reference of unique key which you are referring,range of your reference list, column no in reference list whose data you want to recall, False for exact match)

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.