Match Function

[srirajsa]

Sir

Can I find a Match (by Unique ID) and get data from different excel files

For ex:

File 1 e:\Vsemp
File 2 e:\Jgemp

Main Data File

Emp No Emp Name

9325
9326

I want to check the Emp No from all the files and IF he is not present in file 1 then go to file 2 and get data

Iam generally using Index and Match function which i learned from here but I m little confused how to get this from different files

Regards

Srinivas

 

[bosco_yip]

Upload a sample file and together with your expected results

Regards

 

[srirajsa]

Sir

Im sending here sample file of my working SalMain is the main file I want to get data from Sal JG and SalVs

Thank you

Srinivas

 

[bosco_yip]

Hi,

Try to use IFERROR function, and something like…….

In "Salmain" workbook "Sheet1" B2, formula copy down :

=IF(A2>1,IFERROR(INDEX([SALVS.xlsx]Sheet1!$C$2:$C$10,MATCH(A2,[SALVS.xlsx]Sheet1!$A$2:$A$10,0)),IFERROR(INDEX([SALJG.xlsx]Sheet1!$C$2:$C$10,MATCH(A2,[SALJG.xlsx]Sheet1!$A$2:$A$10)),"")),"")

Edit : Change the above "file path/sheet name" to suit with your own computer.

Regards
Bosco

 

[srirajsa]

Thanks a ton sir its working can you tell me this part "")),"")

and if I want to get data from 6 files means how to end the formula "")),"")

Regards

srinivas

 

[bosco_yip]

Thanks a ton sir its working can you tell me this part "")),"")

and if I want to get data from 6 files means how to end the formula "")),"")

Regards

srinivas

To get data from 6 files, something like.......

=IF(A2>1,IFERROR(File1Formula,IFERROR(File2Formula,IFERROR(File3Formula,IFERROR(File4Formula,IFERROR(File5Formula,IFERROR(File6Formula,"")))))),"")

Regards

 

[srirajsa]

Thank you sir

Regards

Srinivas