• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match Function

srirajsa

Member
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
 
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
 

Attachments

  • SALJG.xlsx
    9.2 KB · Views: 1
  • SALMAIN.xlsx
    11.6 KB · Views: 2
  • SALVS.xlsx
    9.1 KB · Views: 1
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
 
Last edited:
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
 
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
 
Back
Top