I'm trying to put together a spreadsheet that gets its data from another Excel file.
Here is the formula I'm using currently:
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!