Hi I am attaching the data which contains master data in one sheet and in the output sheet if select the drop menu of the three criteria like Role, Region & Experience the Average CTC should come in the last column. Regards Shahul