Forum Discussion
Data completion
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...
1) you can do it via Conditional Data Validation
https://www.got-it.ai/solutions/excel-chat/excel-tutorial/conditional-formatting/conditional-data-validation
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