Trying to fill cells with data from separate excel file based on specific value in row

[xlyfe]

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.

[xlyfe]

=INDIRECT.EXT("'C:\Users\mrodriguez.TWKS\Desktop\[Sorrento 2 Database - Working.xlsm]Sorrento 2'!???")

That's the formula that I have in my cell that I'm trying to get to extract data from a table in the other file "Sorrento 2 Database - Working.xlsm". But I only want to extract that data from the row that has it's first column match the value from a specified cell (L1) in the document that I'm working in (S02-0001.xlsx).

I feel like I'm halfway there because if I replace those question marks with the cell location of the value I want to have in there, in this case it's (B2), then it carries over the data no problem. But that's not what I'm trying to do. I would like to not have to put (B2) in that cell, instead, some other portion of the formula that will tell the cell to look in (Sorrento 2 Database - Working.xlsm) for a row of data which its column A value matches that of cell (L1) in my (S02-0001.xlsx) file.

I have a feeling I'm being a bit redundant here in my explanation of my issue. I apologize if so. This is just driving me bonkers because I feel like I'm so close to getting this thing solved.

Also, I have what I think will turn out to be a dumb question, but I'll ask it anyways. How would I go about attaching a file to my post here? Sorry, I'm sorta new to this place. But I'm going to be touching up my excel skills quite frequently with my current duties at my job, so I think I'll be around often seeking the genius that most of you possess.

[xlyfe]

I think I found a better way to describe what I'm trying to do. Last post to try and explain this, I promise.

I'm working in a file called (S02-0001.xlsx). I would like for cell (H2) to copy a value from a specific cell in another file (Sorrento 2 Database - Working.xlsm). This specific cell needs to be located by searching through column A in (Sorrento 2 Database - Working.xlsm) for a value that matches cell (L1) in my other file (S02-0001.xlsx). Once that cell is located in column A in the other file, I need to start extracting data from that cell's row. In this case, once row is identified, I would like to pull the data from that row's, column B.

[xlyfe]

SO2-0001.xlsx

Sorrento 2 Database - Working.xlsm

Found the Advanced button and figured out how to upload the files. Here they are for anybody willing to give helping me out a shot.