Help! Essentially if A2 were office support and b1 and c1 were Quarter and Fiscal year, respectively, then provide me multiple criteria (categories) provided in column K. Something like:

If(and(a2=(datatab!A:A,and(b1=(datatab!B:B,and(c1=(datatab!C:C,lookup(datatab!K:K,{"BD: A1","BD: A2","BD: A3","Research","Conferences","HR","Training"