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

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*

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