Vlookup returning a drop down list (data validation)

[Boothy999]

Hi,

I have 2 sheets in a work book.

The first is a summary list of codes and their titles, with a column for "code titles". Some of these "titles" are simply one-off titles, some are drop down boxes where a choice can be made.

The second sheet is a list of similar code data, where I wish a vlookup to return the titles from the first, however, the vlookup doesn't return the drop down, just a 0 (as nothing has been selected in the source list).

Is it possible in the second sheet for the vlookup (or other function) to return the drop down list from the summary sheet, when one is present?

Thanks

Chris

 

[Boothy999]

bump

 

[Boothy999]

As an example my summary list is as follows:

Contract Descriptions!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Analysis Title[/TD]
[/TR]
[TR]
[TD]xxx-aaa[/TD]
[TD]Title 1[/TD]
[/TR]
[TR]
[TD]xxx-bbb[/TD]
[TD]Title 2[/TD]
[/TR]
[TR]
[TD]xxx-ccc[/TD]
[TD]"Data Validation drop down with choice of "Title 3; 4; & 5"[/TD]
[/TR]
</tbody>[/TABLE]

Data List (with vlookup as its currently returning B(x)=VLOOKUP(A(x),'Contract Descriptions'!K:R,8,FALSE)):

[TABLE="width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Vlookup to Analysis Title[/TD]
[/TR]
[TR]
[TD]xxx-bbb[/TD]
[TD]Title 2[/TD]
[/TR]
[TR]
[TD]xxx-ccc[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]xxx-aaa[/TD]
[TD]Title 1[/TD]
[/TR]
</tbody>[/TABLE]

As you can see, the vlookup against code "xxx-ccc" returns a 0, not what I want, which is the drop down menu with its relevant choices as it appears in the source list.

Is what I want possible?

Thanks

 

[Newport Count]

You could add an IF function to the VLOOKUP?

If cell value is "" then "Title 3; 4; & 5", that should work (I've tried to add to your code below, but I dont know the exact location of your data!:


B(x)=IF('Contract Descriptions'!R1="","Title 3; 4; & 5",VLOOKUP(A(x),'Contract Descriptions'!K:R,8,FALSE))


I hope that is some help


Cheers,
Rich

 

[L. Howard]

Post the actual VLOOKUP formula you are using.

What column is the Code in?

What column is the Title 2 and Title 1 in?

What cell/s is the lookup_value in?

If your table_array is K to R then you are looking in column K for a match? Correct?

If that is true and your formula finds an exact match in column K then it will return whatever is in 8 columns to the right, which is R.

So column R is where you have text like Title 2, Title 1 and some cells in column R have a drop down that you will select from a list that may be like Title 5, Title 6, Title 7. Is that correct?

In my little test I have no problem returning what a drop down shows in a cell.

Howard