I am writing an IF formula and though I searched here I couldnt find one. I am in need of a method to assign a value to every other resource.
for example I have a list of 1000 potential assignments. Each assignment has certain other criteria assigned to it based on values like "State" and...