Andrew Watson
New Member
- Joined
- Feb 3, 2016
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I have a dilemma whereby I'm trying to populate a column of data from tab to another using a partial match for the data. The issue is I have to start with the whole number, in this case 31N11145 and then find an FX Currency Rate on another tab of the same workbook but the cell only contains N11145.
Using the instance below my "Master Job" in Column G is on the Master Tab and I need to add in the FX Rate in column J of the same tab. The "FX Job" column A and "FX Rate" column D appears on the FX data tab. I'm trying to populate column J by trying to partial match the data in column A using the full data in column G. If I were to swap columns A & J everything works fine but I can't do that, nor can I simply add 31 to the start of column A as there is other data in there that cannot be changed as it already has a 31 prefix for other jobs. I've searched and searched multiple posts but turn up with nothing. Any help is most appreciated.
Thanks Andrew.
I have a dilemma whereby I'm trying to populate a column of data from tab to another using a partial match for the data. The issue is I have to start with the whole number, in this case 31N11145 and then find an FX Currency Rate on another tab of the same workbook but the cell only contains N11145.
Using the instance below my "Master Job" in Column G is on the Master Tab and I need to add in the FX Rate in column J of the same tab. The "FX Job" column A and "FX Rate" column D appears on the FX data tab. I'm trying to populate column J by trying to partial match the data in column A using the full data in column G. If I were to swap columns A & J everything works fine but I can't do that, nor can I simply add 31 to the start of column A as there is other data in there that cannot be changed as it already has a 31 prefix for other jobs. I've searched and searched multiple posts but turn up with nothing. Any help is most appreciated.
Thanks Andrew.