Forum Discussion

strongjj's avatar
strongjj
Copper Contributor
Feb 25, 2018

Excel cross referencing from one sheet to another using drop down box.

I have built a workbook with two sheets, the first sheet being a list of names with qualifications and the second being a "look up" sheet to search for members who have specific qualifications.  I can't seem to get the search sheet to work for me and have googled the heck out of it with no luck.  Anyone able to help?

Formulas & Functions
Requests

3 Replies

  • strongjj's avatar
    strongjj
    Copper Contributor
    Feb 25, 2018

    Got a solution from else where, D11 on the lookup sheet 

     

    =IFERROR(HLOOKUP($D$8,$M$10:$AI$60,ROW(A2),FALSE),"")

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 25, 2018

    Hi,

     

    Please put this formula in cell D11 of the lookup sheet and drag it down:

    =IFERROR(VLOOKUP(C11,All!$Z$4:$BG$46,MATCH($D$8,All!$Z$3:$BG$3,0),0)&"","")
    • strongjj's avatar
      strongjj
      Copper Contributor
      Feb 25, 2018

      Ok, I tried that, it just gives them all zeros as results.

       

      As for what I am trying to do, anything in red will be hidden once complete. The first sheet (Titled "All") is working fine. The Second sheet (Titled "Look up") isn't working. I am trying to get the drop down box to list all the names in the corresponding column, they would be qualified that qualification.

Resources