Data Validation Dependence

I am looking to create a data validation drop down list that would also affect the column next to it.

I have 2 reference columns, one called CONTRACT and one called PRICE on a reference worksheet. I already have a drop down list that lets me chose the Contract of my choice. What I'm trying to establish is that when I chose the contract number from data validation in column A, the corresponding price also appear in column B.

hi,


suggest you use vlookup

steve

Originally Posted by Macdave_19

Oh the wonders of the Indirect function:

http://www.contextures.com/xlDataVal02.html

Hope that helps

Yes and No. I don't want a second data validation for the price. I need it to automaticaly put in the price when I chose the contract number.

Originally Posted by stevekirk

hi,


suggest you use vlookup

steve

The Vlookup worked.... good thing Contextures.com has sample files for those....

Final formulla:
=IF(ISNA(VLOOKUP(A6;PO!$A$3:$B$1000;2;FALSE));"";VLOOKUP(A6;PO!$A$3:$B$1000;2;FALSE))