Returning multiple entries with INDEX and MATCH

[jessea]

Hello everyone,

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)

Obviously, the reason I'm not using VLOOKUP is because I have to get data from a cell to the left of the column I'm referencing. This formula works for getting the first matched entry, but I need to retrieve about a dozen other entries from other rows that match.

I'm not sure how to re-write this so that I can get the other rows. I've been experimenting with IF functions but can't get it to work the way I want.

Any help would be greatly appreciated. Thanks a lot!

Jesse A.