Using indirect worksheet functions and vlookups

Hello everyone. I have the following snippet of code that I use to assign a cell in a worksheet a variable from VBA:

Sub Update_Formulas_Data()

    Dim sPath1      As String
    Dim wb1         As Workbook
    Const sFileInp1 As String = "Formulas.xlsm"
    
    sPath1 = fPath & fDate & "_157\Support_Summaries\"
    
        Set wb1 = Workbooks.Open(sPath1 & sFileInp1)
        Range("AV1").Value = fPriorDate
        Range("AV1").NumberFormat = "dd-mmm-yyyy"
     
End Sub

It works. I need help creating a vlookup formula which will use that cell refernce. First I have to concatenate the cell reference with the suffix "_CDS", and I must do so while mainting the dating format, dd-mmm-yyyy. Thats is where I am currently stuck. After that is done, I believe I should be using the Indirect worksheet function, but I am not sure how that is done. Any help is greatly appreciated.