multi range identify & replace
 

i have a master ref. in a separate sheet. grade 52 to 59; each grade carries
4 quarters. every quarter carries min & max.

i have employees salary on annual basis. now, i have fill for all the
employees, on employee belongs to which quarter based on their grade.

master data in one sheet & 1000 employees list in another sheet.

pls help me