Searchable drop down list

Hello!

I've been struggling with a searchable drop down list.

I have created a searchable drop down list that searches names/data from first column.

The problem is that when i am getting data from the first column i would also like to see next to it data that is located in different columns but in the same row.

I've added a table and the second sheet (How it should look) has light blue are that illustrates what i mean.

Thanks in advance

Try the below and see if it helps.

=IFERROR(INDEX(N2:N65,MATCH($E2,$M$2:$M$65,0)),"")

It just solved my problem

Thanks a lot adagio!

A pleasure roadwreck, glad it helped.