I have created a drop down cell via data validation cell A2. This contains
text and part numbers I need to appear. The data validation list, M2 thru
M200, have pricing in the adjoining cell, N2 thru N200.

Below A2 (part number text) is where I need the price to automatically fill
in, cell A3. How do I pick, lets say Hammer €“ cell M2, from the drop down
list and have the price €“ cell N2, lets say $12.00 fill in to cell A3?