I am attempting to reference another sheet within excel which i know is the function =sheet1!(cell)
But I wish to automate the possess using from a match function.
I would like it to look something like this = sheet1!$B(=MATCH(2, Sheet1!A1:A55, 0))
where the =MATCH(2, Sheet1!A1:A55, 0) is the row reference.
Is there any way to do this.
I have attached an example of what I have tried to do.
Bookmarks