drop downs & data validation

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?
 
J

Jim Rech

Try this formula in A3:

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

--
Jim
|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?
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up a value next to a designated cell 3
Data Validation From Different Workbook 2
auto fill or auto search from a list or drop-down list??????? 9
Data Validation Formulas 4
empty cells in the drop down list 7
Excel 2007-macro programming logic for data validation 2
Data Validation - Cell Colour 3
Creating drop downs in a cell contingent on another drop down 1

Top