Hey guys,

So I have 2 workbooks which I am using. One workbook (lets call it signals) never changes it's format and contains a row of many signal names (example of a signal name : 'RF_Decoding_analysis::RF_Avg_SNR_RR'). This workbook is created from data exported from a program every time a new test is ran creating a CSV file. Under each signal I would like to retrieve the last value in the column. The other workbook (lets call it values) is where I would like to store the 'searched for' values of signals.

For the signal workbook, this will be overwritten every time a new test is ran as there will be different values under each signal. The main idea behind what I am trying to do is to allow the values workbook to auto-populate with the signal values each time a new test is done. A pathway or flow would look like such:

VALUES WORKBOOK - GO TO SIGNALS WORKBOOK - SEARCH FOR SIGNAL NAME - GO TO THAT COLUMN - RETRIEVE LAST VALUE - PLACE IN VALUES WORKBOOK - REPEAT FOR ALL SIGNAL NAMES AND VALUES.

I have tried multiple options such as 'VLOOKUP' and 'INDIRECT' but i find when I come to use 'VLOOKUP' I can't insert or dont know how to insert the address of the column that the signal name is in to get the value.

Any advice or solution would be greatly appreciated!

Thanks,

Ryan