assalam alikum friend here i will tell how to work with Vlookup function in excel using picture tutorial.
here we have merge cell into one cell
create simple employee table
after creating the table
as you have seen in picture Vlookup(lookup value,table array,col index,range lookup)
- lookup value contain id do you want search
- table array is range of entire table you want your result to show
- col index is column number
- range lookup is result match
apply function
insert id you want search
show the result of searched id
Comments