Thank you mathews. I used similar thing and it worked. This is the formula that i used.

=IF(AND(H18=VLOOKUP(H18,'[Asset_movm_form.xlsx]Asset movement details'!$H:$H,1,0),H16=VLOOKUP(H18,'[Asset_movm_form.xlsx]Asset movement details'!$H:$I,2,0)),VLOOKUP(H18,'[Asset_movm_form.xlsx]Asset movement details'!$H:$M,6,0))

But now to look more better, i am trying to use Iferror function to eliminate the false values. I am not sure if this works or not, but is there a possibility that when the value is false, the cell turns to a different color? let me know your thought.

Again thanks so much for your time and suggestion. I could learn a new formula.

regards,
david