I'm trying to put together a spreadsheet that gets its data from another Excel file.
Here is the formula I'm using currently:
=INDEX([other_file.xls]Sheet_1!$A$2:$A$1000,MATCH($M$1,[other_file.xls]Sheet_1!$E$2:$E$1000,0),1)
It returns the first match just fine, but if I copy it down to the rows below it just gives me back the same match (obviously). Is there a way to modify this formula so that it checks for results already given and only gives unique ones in every row?
I posted this same question on another forum as well: http://www.excelforum.com/showthread.php?t=644756
Filters are not an option for me on this project. Any help would be greatly appreciated. Thanks a lot!
Jesse A.