What vlady post has given me some hint. But i don't know how to input the formula. I use index. But the problem is that all the value might appear more than once. And excel automatically give me the most upper search result when i use Match. I need a Double Match. match the Contract then match the Room.........