I was asked to concatenate two excel files into another excel master file. The files should be combined by 2 columns. I can only match by one column and have no idea how to do multiple column matching. i have to match the values in two columns with the values in the master file.. Can anyone help?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Concatenating Excel Files
- Thread starter macko
- Start date
Robert Mika
MrExcel MVP
- Joined
- Jun 29, 2009
- Messages
- 7,256
Re: Matching numbers in two Columns
You shoudl have opened your own thread.
(reported to moderator)
The syntax for your formula shoudl be like this:
=index(result_colum,match(TRUE,index(first_colum&second_column=first_condition&second_condition,),0))
You shoudl have opened your own thread.
(reported to moderator)
The syntax for your formula shoudl be like this:
=index(result_colum,match(TRUE,index(first_colum&second_column=first_condition&second_condition,),0))
Upvote
0
Similar threads
- Solved
- Question
