Combining IF and Index Match

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.

It is much easier to respond if we have data to work with so please post a sample file (not image).

file attached

How is your data organised? Do you have two columns (like a "Unit" and "time period" column, and you want the result in the third column)? "Are the columns "2ND Price", "3RD Price" all next to the other and in order? If so, you could use VLOOKUP, something like =VLOOKUP(A2,DATA!$A$1:$K$10000,B2,FALSE)

Edit: Now that there's an attachment, where do you want your answer and based on what?

I posted the attachment above if anyone can help

where do you want your answer and based on what?

Please answer the question posted by Jdevel in post#4.

where are the parameters placed?

Please add examples to your posted file