Index Match Collect

I need to match a price across different columns from another sheet that contains correct pricing. Can you please help me to create and index match formula?

My data looks like below

Price list looks like below

I tried to create one but got error message

=Index(collect,([Part Number]@row,[Sales Person]@row,[Key Account]@row,{Resale Range 1},1])


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!