Excel 2016 - Data Validation Formula Based on a Selection in Another Data Validation Drop Down List

Question

I need help with creating a formula in a custom data validation for the cells in column Z whose result is dependent on the choice made in list data validation cells in column W. Column W's dropdown list is based on table 1. I want column Z to go to table 2 and in table 2's column B locate the text selected in column W's cells and return in the cell for column Z what has been entered into the table 2's column C and corresponds to table 2's column B.

I tried this formula and it gives me an error.

=VLOOKUP(W12,'table_2'!$B$2:$C$10,2)

Any assistance would be greatly appreciated.

Excel 2016---> Table 1--->

Table 2--->

Answer 1

Re: "Dependent Data Validation Lists"

Almost all the answers for DV questions from Debra Dalgleish ("Contextures")

and more. Pack a lunch.

https://www.contextures.com/xldataval02.html

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)