Multiple Drop Down menu starts from Top

[toci]

Hello folks.

I have multiple columns that I am using for drop-down menu and this is the formula that I put in "Data Validation" under "Source" in order to match drop down list based on header.

Please Login or Register  to view this content.

But, my problem here is that my drop-down list starts from bottom and I would like to start from Top. I am trying something with OFFSET formula but don't know how to nest it within this INDEX.

Attached is the example.

Any idea how to resolve this?

Thanks.

[modytrane]

See attached. The drop downs tend to go to first blank cell in the range.
So adding a blank at the top of the range will help.

[Bo_Ry]

Please try Data validation List source at E2

=OFFSET($A$1,1,MATCH($E$1,$A$1:$C$1,)-1,COUNTA(INDEX($A:$C,,MATCH($E$1,$A$1:$C$1,)))-1)

[toci]

Please try Data validation List source at E2

=OFFSET($A$1,1,MATCH($E$1,$A$1:$C$1,)-1,COUNTA(INDEX($A:$C,,MATCH($E$1,$A$1:$C$1,)))-1)

I have tried this solution and it works perfectly!

Nice job man, thanks a million!