Linking columns

[Johnny Image]

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

[newdoverman]

This simple example should help you get a solution for your real data.

[Johnny Image]

This simple example should help you get a solution for your real data.

Almost exactly what I was looking for. It's enough to give me a push in the right direction. Thank you so much for the help!!!

[newdoverman]

You are welcome.

Good Luck