Data Validation List from a VLookup Cell

[kiz1988]

Hi,

I am new to all of this, so apologies if I don't explain myself very well

Basically I'm trying to make an interview document for my company so that when a manager selects the level of the job in cell 'A,1' (i.e. "low", "medium" or "high"), the following cell 'B,1' then displays a competency (i.e. "Customer Relationships") relating to this level (i.e. "low - Customer Relationships", "medium - Customer Relationships" or "high - Customer Relationships"). I have managed to create this part by performing a VLookup, so that when you select 'Low" in cell 'A,1', "Low - Customer Relationships" is then displayed in 'B,1'

Now for the confusing part....

Based on what is displayed in cell 'B,1' I then want a list of competency questions to appear as a drop down list in cell 'C,1'. I'm presuming that this is some sort of Data Validation formula, however I can't seem to work it out.

I have looked at so many youtube videos, but none of them seem to answer this question. I'm not sure whether is is because the cell that I am using as a reference point for my data validation formula ('B,1') is a Vlookup formula or if it's because you are unable to perform data validation on a cell that is already formulated?

Your help would be much appreciated

Thank you,
Kieran

[Kevin UK]

Hi kiz1988

Have a look at the site below, with reference to data validation & dependant lists.


http://www.myonlinetraininghub.com/e...ependent-lists

[kiz1988]

Hi Kevin,

Thank you for this

I worked out that I needed to use the Substitute function, as the text that I was using contained spaced. So the formula I entered into the data validation contained the indirect & substitute function e.g. =INDIRECT(SUBSTITUTE(A107," ","_"))

I hope this helps someone who experiences this problem in the future