I am looking for a way to link columns together. I have created a template that pulls data from another spreadsheet. I have two columns that I need linked together. Column A is product names and column B is prices. The names are static, but the prices change fairly often. I have an array formula pulling the prices from another source for coulmn B, but I need a way to link it to the names in column A. The reason is that the source data belongs to another dept and they sort the spreadsheet and it throws my template off. Is this possible?

Column A CoulmnB {=[prices.xlsm]sheet2'!$J$4:$J$40}
product1 price1
Product2 price2
Product3 price3