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)&"","")