G
Guest
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, let’s say Hammer – cell M2, from the drop down
list and have the price – cell N2, let’s say $12.00 fill in to cell A3?
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, let’s say Hammer – cell M2, from the drop down
list and have the price – cell N2, let’s say $12.00 fill in to cell A3?