Hi All,
I am creating a key management system for our properties.
On the first tab 'Key Sets': I list all our properties with the number of sets, I give the key number as a reference to that property and if that property is sold I can always replace it with another address with that key number. The column of Set Left is where I am struggling to put the right formula...
Set left: how this should work is that it looks up from the second tab called 'Key tracker', it should looks at the whole table with data (when entered), and if the key number from the table column 'Key Set tab' matches the table column Key Number on 'Key Tracker tab' this should minus from set left (Key Tracker->No of set taken: e.g if you take 2 sets - its should minus 2 from Set left), and then if you returned it should add it back on to Set Left (Key Tracker ->No of Set Return). I am still a novice using formulas on excel so pardon me if this is a simple formula.
I hope this makes sense.
I hope that I have attached the file correctly.
Please feel free to ask any question, I really appreciate your assistance.
Thank you.
Bookmarks