Sir,
i upload new sheet in which i asign colour to which i want to match with different sheet.
I want three Match
1) Name of Work (Comparitive F2 = Chart A3)
2) Name of Agency (Comparitive i7 = chart f6)
3) desricption of Item (Comparitive d10= chart b8:b20)
and desired result taken from chart...