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

2 Replies

  • 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.

  • WassimN's avatar
    WassimN
    Copper Contributor
    Apr 05, 2026

    Hellosj47​ 

     

    OK, when you say “the most prevalent condition" do you mean the one that appears the most in the list of conditions?

     

    Typically when you want to “copy” data from one sheet to another you can use something like =Sheet1!A1 in Sheet2 cell A1. That means whatever is in cell A1 on Sheet1 should be in cell A1 on Sheet2.

     

    The Dropdown will change the cell value to the chosen item from the dropdown. So you can use the same formula just make it point at the cell where the drop down is.

     

    I hope this helps. If not, please explain more with a better examples like:

    I need to copy cell xxx value to cell yyy on sheet aaa.