Formula to look in filecell based on cell value in next column?

Hello! I am wondering if it is possible to put a formula in a cell that can go into a file based on a number in a cell to the left of it.

As you can see in the image, in Column A there is a filename with a hyperlink, and in Column F there is a status.

I would like the status to be found by the cell searching in the respective file in column A for cell(2,2) (B2)'s current value. (That is where the status is placed)

Is this possible?

Can I reference the file in the first cell in the row to find the status? Thank you for any help in advanced!

helpquestion.png

Thanks for your response Jeff!

Unfortunately that would not fit in the safety guidelines at my workplace. Thank you anyway! We will just have to do it manually if there is no way to write a formula in for it.