Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do excel shows "value!" by using vlook up?

user-image
Question added by Tanay Majumder
Date Posted: 2016/10/05
Natalie Joy Guanio
by Natalie Joy Guanio , Internal Audit , Union Bank of the Philippines

VLOOKUP Syntax (lookup value,table array,column index number)to show the value using Vlookup followed by the steps and check the images for your guidelines: 1.Add your new column on the original worksheet that will display the info pulled from the lookup table. 2.Place your cursor in the first blank cell in that column. 3.From the Insert Menu, Select Function "The Function Dialog will appear" 4.In the Search for a function "Text Box:type VLOOKUP" Click Go to make it Run. 5.Highlight Vlookup and click Ok *Lookup_Value-Think of this field as your starting point* *Table_Array-This is the range for your Lookup Table*

jimson JOHN
by jimson JOHN , Modern Trade Analyst UAE , Fine Hygienic Holding

VLOOKUP Syntax is (lookup value,table array,column index number) .Input your desired lookup value then select the array to lookup .Note to select lookup value column as the first one .Give the column index number as the column number of the desired result

More Questions Like This