DaveRadford
Board Regular
- Joined
- Feb 18, 2010
- Messages
- 63
Hello Guys,
Quick Question, I have a data validation box and a vlookup in order to get descriptions when a job description is chosen from the data validation box.
I now need to to do the same reversed, this in theory is simple however, if i type the description ill need the Job Number to appear in the Job Number validation part. This will mean that the Vlookup or Match statement for looking at the description and finding the Job number to display will need to be in the source of the data validation.
I am already using one source to populate the DV box in the first place so i believe ill need to add an OR Statement to the source.
Something like the following:
=LiveJobList OR =INDEX('LIVE JOB LIST'!$A$2:$A$2700,MATCH(D12,'LIVE JOB LIST'!$B$2:$B$5000,0))
I would want it to either display the Job list if the drop down is clicked or display a Job Number if a correct Descrption has been entered.
Hopefully this will be nice and easy and i have explained it well enough.
Thanks,
Quick Question, I have a data validation box and a vlookup in order to get descriptions when a job description is chosen from the data validation box.
I now need to to do the same reversed, this in theory is simple however, if i type the description ill need the Job Number to appear in the Job Number validation part. This will mean that the Vlookup or Match statement for looking at the description and finding the Job number to display will need to be in the source of the data validation.
I am already using one source to populate the DV box in the first place so i believe ill need to add an OR Statement to the source.
Something like the following:
=LiveJobList OR =INDEX('LIVE JOB LIST'!$A$2:$A$2700,MATCH(D12,'LIVE JOB LIST'!$B$2:$B$5000,0))
I would want it to either display the Job list if the drop down is clicked or display a Job Number if a correct Descrption has been entered.
Hopefully this will be nice and easy and i have explained it well enough.
Thanks,