Hi All please find the attached spreadsheet, I'm having a problem making the drop down list in (D3) and in (A23) work together at the same time. I want to be able to control the value in (K23) by choosing either drop down list. So for example I choose a name in (A23) it will bring up a value in (K23), then when I change the item in the drop down list in (D3) I want the value in (k23), all fed by the attached tables. Any help would be appreciated as I'm struggling with this. thank you. https://docs.google.com/file/d/0B50j4eNSlSxjQVNqdzhIal95bEU/edit?usp=sharing