How to use Iferror and Vlookup formula in multiple worksheet with example

You want to find a employee details from another excel sheet that means you want to use Vlookup formula in multiple excel worksheets, this article helps you how to use Vlookup formula in multiple worksheets and also assists you to use multiple column of Vlookup. Look like the image if you want to such a data base to find employee details or others.

Vlookup Formula:

=Iferror(VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup],True/False),0)

=IFERROR(VLOOKUP(C4,Sheet1!1:1048576,2,FALSE),0)

Look the image above, here C4 is the value cell where I put the employee id that automatically change the employee details such as employee name, designation, phone, mail and which company he/she works that saves you time to find the details just typing the ID and works smartly but here we works two excel worksheets look the image below;

In sheet 01 we arrange the employee data where in column A we show employee ID, Column B show name and gradually Colum C show designation, then Column D show mail id, then Column E show phone and finally column F show company. Look the image below;

Now work with the formula of Vlookup and Iferror

=IFERROR(VLOOKUP(C4,Sheet1!1:1048576,2,FALSE),0)

Type the formula =IFERROR(VLOOKUP(C4,Sheet1!1:1048576,2,FALSE),0) in cell C7

here C4 is the value cell where put employee ID like 101, 102 etc

Sheet1!1:1048576 is the source cell from where show the employee  information. Look the image below;

2 is represent the column number which information do you want. Here the column 2 is the name column, 3 is the designation, 4 is mail, 5 is phone and column 6 is company information. If you want designation, please type  the formula below;

=IFERROR(VLOOKUP(C4,Sheet1!1:1048576,3,FALSE),0)

If you want mail id, please type the formula =IFERROR(VLOOKUP(C4,Sheet1!1:1048576,4,FALSE),0)

Finally just type the column number you can find any information you like.

False represent  exact match of your information and complete the formula type comma and zero.

If you want the excel template, please download the excel file from the link below.

Download