IF, then VLOOKUP from another workbook with Conditional Criteria

A change up in my plans has lead to me needing to create a formula that:

• IF cell G5 = "text" then
• VLOOKUP cell F5 in workbook C:\test\Test_Workbook_DATE.xlsx (where DATE is actually cell H5 in the current workbook)
• Sheet is Data_Sheet
• Vlookup table range, LEFT(A:A, LEN(A:A)-3):C trying to trim A in order to match to F5
• Return value is from column C in the table range

My attempt so far is:

'=IF(G5="Text",VLOOKUP(F5,"C:\Test\[Test_Workbook"&TEXT(H5,"YYYYMMDD)&".xlsx'!Data_Sheet'!TRIM(A):C,2),)

Problem is, this just returns a blank cell when it should return the number from column C. Any hints on where i'm going wrong/how to get it to work and improve syntax is greatly appreciated!