height of dropdown list with validation

[blooddiamond]

Hi guys,

I created two drop-down list with the second one depending on the first one. Since the list does not have the same height, I tried to help me with the following formula.

=OFFSET($N$3,,MATCH($K$2,$N$2:$AD$2,0)-1,COUNTA(INDEX($N$2:$AD$2,,MATCH($K$2,$N$2:$AD$2,0))),1)

the problem is, that the height of the list stays 1. the problem should be somewhere in the COUNTA formula


Hope you can help me and thanks in advance

Jo

[dredwolf]

Please Upload a sample workbook, I think I might have a solution, But without being able to test it, I won't offer it
See My Signature below for details on Uploading a sample workbook

[blooddiamond]

thanks for the reply.

A1 is the first list containing D1:G1

B1 is the second list that should display column D, E, F or G

[dredwolf]

Try this for your Data Validation formula instead:

Please Login or Register  to view this content.

Hope this helps

[blooddiamond]

awesome. thank you.

one follow up, is it possible that after selecting from the first list it automatically displays the first entry of the second?

[dredwolf]

Its probably doable with VBA, but I am not really sure of how to go about it...as far as I know, there isn't a way through Excel formulas to make it happen...about the best is to use Conditional formatting to color the text the same as the background, if it isn't in the new list...

Sorry

[blooddiamond]

ok. thanks

[dredwolf]

You are welcome