# Vlookup Excel

at the top we want to extract someones last name from his id we can solve that with you guessed it the vlookup function

when using the vlookup function in microsoft excel why must the lookup value be in the first column of the table array what if i want to use vlookup using

vlookup to the rescue let us go ahead and merge company data from company file into the contacts file in few simple almost steps

when i run vlookup formula for e it doesnt find the appropriate value but all the other formulas gives the correct value as shown in the picture

the vlookup function that is employees salary is listed in sheet which is to be searched by vlookup and reference of the column index is as per