Forum Discussion

sj47's avatar
sj47
Copper Contributor
Apr 03, 2026

How to get info from a dropdown list in an excel sheet into another sheet in the same workbook?

How do i get "the most prevalent condition" result from a drop down list of conditions in an excel sheet into another excel sheet within the same workbook?
Formulas and Functions
Olufemi7's avatar
Olufemi7
Iron Contributor
Apr 06, 2026

Hellosj47​,

=Sheet1!A1 to show the selected dropdown value from another sheet, =INDEX(A2:A100, MODE(MATCH(A2:A100, A2:A100, 0))) for the most frequent text, or use a helper column with =COUNTIF(A$2:A$100, A2) and =INDEX(A2:A100, MATCH(MAX(B2:B100), B2:B100, 0)) for older Excel.