I need a function/formula that will import all data from all rows in a datasheet that match certain criteria.
e.g if(d:d=d2) and (e:e=e2) import row/rows below

If d:d(column d)=d2(america) and e:e(column e)= e2(food) please import the rows that contain this criteria below



Any help would be much appreciated

Francis