Wanting to retrieve values from external workbook by searching name of column.

Hey, thanks very much for your reply!I have attached the 2 workbooks 'Values.xlsx' and 'Signals.csv' to give more of an idea of what I'm trying to achieve. The main principle is an idea of automation wherein, when a new signals file is made and hence overwrites the old version, the values worksheet will be auto-populated and updated without any interaction or editing in the Signals.csv workbook.

In relation to the solution you have suggested, a '0' is returned into the cell C6 (ref to image) rather than the actual value. I'm needing this formula to search for the actual signal name then go to the column where all the values for that particular signal are and then take the last value in that column.

Values.xlsx

Signals.csv