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
Bookmarks