Hi Forum,

I have managed to master return a list based on another value/cell (index, match and countif) one giant leap.....,however

i now have a situation where the following is true:

"sheet 1"- data entry requires 2 or more data validation which work find (almost)
the data in which the list for data validation is on a reference sheet in separate columns. with the current formula the columns need to be sorted, which is not possible to meet the needs of both dependent list

I assume it is best to have the formula work with unsorted data, however i have not the base idea how to commence working with this challenge.- any guidance would be helpful

example below:

=INDEX('Reference data'!$N$3:$N$50, MATCH('TEAM LIST'!F3,REF_TRG_NAME,0))