drop downs & data validation
 

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?

Try this formula in A3:

=VLOOKUP(A2,M2:N200,2,FALSE)

--
Jim
"burgi" wrote in message
...
|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?
|

Thank you very much. I'm new to this board and appreciate your help!

"Jim Rech" wrote:

Try this formula in A3:

=VLOOKUP(A2,M2:N200,2,FALSE)

--
Jim
"burgi" wrote in message
...
|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?
|