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