Hello again!! This time I have a spreadsheet that contains a lot of data, as well as the workbook and sheet names this data comes from that looks like this:
[Actual Resolution 2019-05 - New.xlsm]Purposeful'!
Another cell with the date in the format of yyyy-mm like this:
2019-05
Another cell with the Path location like this:
X:\Actual\Personal\Resolution\
Another cell that holds a range like this:
$A$10:$A$69
and one last cell that only contains a slash like so:
\
I concatenate all of this information in a final cell AZ2 that turns it into this:
'X:\Actual\Personal\Resolution\2019-05[Actual Resolution 2019-05 - New.xlsm]Purposeful'!$A$10:$A$69
Now I am trying to use this full filepath in a match formula like this:
=MATCH(H14, AZ2, 1)
Where the cell H14 contains my lookup value. However, I am getting N/A. Am I not able to use a reference like this in a formula?? Is there any way I could get this to work?? Any help is appreciated. Thank you!!
Dome
Bookmarks