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...
Got a solution from else where, D11 on the lookup sheet
=IFERROR(HLOOKUP($D$8,$M$10:$AI$60,ROW(A2),FALSE),"")