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.