I have two columns User name and ID in sheet 1 in my google sheet. In sheet 2 I have a list of all the user names and their corresponding ID’s.
I have created a drop down list for column User name in sheet 1 with values picking from the user names column range in sheet 2. The challenge is, how do I make it such that whenever I pick a user name from the drop down list in sheet 1 for User name column, It automatically fills the column ID with the matching ID value from sheet 2
>Solution :
Try below formula-
=INDEX(Sheet2!$B$2:$B,MATCH(A2,Sheet2!$A$2:$A,0))
