I have created a drop down list with part numbers in B2. I want C2 to automatically show the corresponding price of that part number. I have all the part numbers listed in column B40:96 and the corresponding prices listed in column C40:96. How do I format C2?

Thanks!