Drop down lists

Dear Stephen

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

If I am correct in understanding your query you want to select something from column one which is a drop down list and you want the second column which again happens to be a drop down list to be a non drop down list!! Is that right?

I know that you can choose something from one column and have a specific value entered in the adjacent cell by using Vlookup or HLookup. This can also be achieved by using If functions.

I am sure what you are asking for is possible but I would imagine that one of the way of doing this would be using VBA code.

We cover Vloookup and If and nested If statements in our advanced course!

Please refer to the following link to see what other topics are covered in our Excel Advanced level course as well as the schedule for the training.

https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT