I am trying to enter a formula of nested vlookup within a concatenate statements but for some reason it ain't working and I am guessing its probably a syntax issue that I just have not been able to see (trees for the forest scenario)

The formula entered is as follows:

=VLOOKUP(E7467,CONCATENATE(VLOOKUP(D7467,Suppliers!A:M,8,FALSE),"[",VLOOKUP(D7467,Suppliers!A:M,9,FALSE),"]",VLOOKUP(D7467,Suppliers!A:M,10,FALSE),"'!A:H"),2,FALSE)

Using F9 on the concatenate in the Formula Bar to Test the Formula results in the following:

=VLOOKUP(E7467,"'C:\Users\NCU\ICloud - RABBIT HOLE PTY LTD\Price Updates\[suppliers Orders v3.xlsm]OSAL Price Check'!A:H",2,FALSE)

But the result of the formula is #VALUE

What am I not seeing? or missing?

Thanks in advance to one and all