I have a master "DATA" table that I'm trying to link to

If I'm looking for the price of a specific unit based on the period it was sold (1-20), how do I find that.



IF unit "5B" was sold in time period 2, I want it to return the price of unit "5B" pulling from the "2ND Price" column, IF unit "5B" was sold in time period 3, I want it to return the price of unit "5B" pulling from the "3RD Price" column, etc.