Forum Discussion
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 ca...
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)&"","")
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.