So I have these cells in my excel file that I'm trying to get to reference (maybe "reference" is the wrong word) data from a separate excel file. The tricky part (I think it's tricky) is that I'm trying to get these cells to pull this data only from a specific row based on whether or not the leading cell of that row matches the value from a cell in the worksheet that I'm trying to get the data too.

I apologize if I'm wording my question incorrectly.