Please provide more details about the specific database and version. Different applications perform calculations in a different manner.
The data base is as folllows
A B C
Branch Dept Code
Mum it 141
Mum acc 142
Mum cdg 143
Del it 144
Del acc 145
Del cdg 146……
Like this the master data base contains this details
In a new sheet I want a formula that will automatically give me Code when i put Branch & Dept.
This is not really a database – rather a listing of items. How do you ensure that for same Dept and Branch there is not more than one Code? Need to define tables and their relationship.
If it is just plain data then you may be better off to use Excel.
Just an observation – may be I missd your point.