Correction in function

[Karnik]

Hi Experts,
When following function is used for matching , it gives blank result in column D

IF(ISNUMBER(MATCH(($C$2:$C$11),A2:B2,0)),C2,"")

( Col D numbers are written manually and above function to give results after correction....
Sample file attached


A B C D

2 4 1
1 2 3 1
6 8 5
7 20 7 7
6 14 9 14
11 13 10
8 21 12
26 28 14
11 16 16 16
18


Thanks
Karnik