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...
Sir I want lowest tender rate given by firm come to First No and arrangement of Rest all the firms not a issue. Example given in excel sheet. Thanks for help to solve my problem.