Data completion

[TomerBA]

hey, i have couple of questions :

i would like to know how can i make my workbook to compute the next example

column A contains a TV type - that have been selected from a list - Data authentication

column B contains a TV mode and details - also selected from a list - Data authentication

qustions:

1 - I want that the list in column B will change according to the selected option in column A.

for example - if i choose option 1 (from the given list) in column A, i could choose the next option from list X in column B, and if i choose option 2 (from the given list) in column A, i could choose the next option from list Z in column B.

2 - I want that column C  will compute the price of the specific TV that have been chosen from the options i choose in column A and B.

Thanks for all the helpers. 

[#2]

@TomerBA 

It looks like you need to use dependent drop-down lists technique, sample is here https://www.excel-easy.com/examples/dependent-drop-down-lists.html and you may google for more tutorials.

[#3]

@TomerBA 

1) you can do it via Conditional Data Validation

https://www.got-it.ai/solutions/excel-chat/excel-tutorial/conditional-formatting/conditional-data-va...

2) After that you can use Vlookup function to pick up price for a particular model

If you want me to build the entire model for you, please share the file with all the info

Note: Above link is from Google, not my own site

[#4]

@Sergei Baklan 

i did all the steps as ritten, when i try to do the INDIRECT function i get an erorr, 

"the original value is an error, would you like to continue?"

when i click "YES" i get no drop-down list