In excel, many times we need such formula to
import/move/match/index data from another excel file/sheet by matching
destination cells/ requirements. Excel does not have any specific formula to do
the same. Here, let us show you the technique/formula to import such data from
one specific sheet/file to another according to destination match/requirement.
We will use the following formula:
=index(<column or cell whom need to import>,
match(<specific cell whom required to mach>, <matching column or cells
where the query matches>,0))
Here, we combined two formulas “Index” & “Match” for
this purpose. Let us show you the implementation of such formula.
Following are the steps for implementing this formula
1. Type the “=index(“ where you want to bring/import
the values.
2. In the
second step go to the sheet/file from where you need to import the values and
select the entire column or specific cells. By doing this, in formula bar,
address of the file and cells will be written.
3. Then go
back to the sheet or file and write a comma “,” and then write “Match(“. After this
select the cell which is required to be match.
4. After this,
go to the second or source file/sheet and select the range where you required matching
that specific value. It will be automatically written in formula bar.
5. Then,
place a comma and write “0” in the end. 
6. Close the
parenthesizes (small brackets) twice “))” and press enter.
7. By pressing
enter, you will find the value i.e contact of smith by searching in the
second/source file. You may now drag down to get the value of below data.
That’s all, we have done it.
Here we got the relative data of our specific cells. It quite
useful formula especially for the people working on excel for data maintenance.
