Index/Match to Match entries on multiple criteria

Hi all!

I'll just jump right into it. I am trying to match 2 separate spreadsheets of data based on 3 variables, and pull data from one column in one of those spreadsheets into the other. I will include the file below and add a more exact description later. I used the index/match tutorials online for matching based on multiple criteria, and it worked, but only to an extent. I am stumped, as several values that I can manually look up and find are not being brought into the new spreadsheet, despite the values matching on all 3 counts as far as I can tell. Rather than display the binary 0/1 value that is included in source data, only a N/A is displayed. I am hoping that one of you has had a similar problem and can point me in the right direction.

For specifics, I am trying to match the "Sheet1" with the "Hedge or not" spreadsheet. The three variables I am matching on are "Company name at closing", column A in sheet 1, "Type", column D in Sheet 1, and "Closing Date", column I in Sheet 1. The data I am trying to pull from the sheet "Hedge or not" is column G in that sheet, titled "Hedge-1/Others-0". I am trying to move it to column K on Sheet 1, with the same column title.

For an example of where I can't find why the data is not being pulled, look at row 20 on Sheet 1, with an entry for Abaxis, Inc. I have highlighted this entry. In column K, N/A is displayed, but on searching the "Hedge or not" spreadsheet, I can find the same entry in row 1498, again highlighted, for Abaxis, Inc. on the same date, with the same "Type". Yet on "Hedge or Not", a 0 is displayed for this entry. Can anyone help me explain why certain arbitrary entries are not being pulled over? This is not the only case I have been able to find, and just looking through Sheet 1, it is clear there are way too many N/A's compared to the source data.

FYI, I have removed a significant portion of Sheet1 in order to meet the size requirements.

I look forward to any responses, and thank you!

The problem with row 20 is the entry in A20 has one extra blank on the end so Match fails. Some of the other #N/A errors could be a result of the same problem.

Hi
The flaw is in the data. A20 in sheet1, the "Company Name at Closing" has an extra space at the end.
Also on the sheet "Hedge or Not" in the same field has in A2515 value without point at the end.

Regards