how to compare values or look values Using zoho creator

how to compare values or look values Using zoho creator

Hi  I am a  Master Dealer from different  CELL PHONE companys.  I have this situation: In my position I can not  follow my activations per Resellers.  My Master Agents only give me at spreed sheet of Activations serial numbers.  But I dont know which reseller activate x -serial #.  I want a data base of my Clients Resellers where I can assign serial # inactivated.  Then when I received my excel activation report. I want to upload the excel activation report to my zoho data base and run a report that says to me  Activate serial # by reseller base on the report up loaded.  I can do that in a zoho spreed sheet using look up values, but I realize that will be very uncomfortable with  50 or 100 Clients.  I need to create a data base with that feature.

Can I compare values in Zoho creator like I do in a zoho spreed sheet?