Formula to Identify difference in dropdown columns without numbers
I am working on a sheet that has three columns where two are drop downs (Current and Desired) with the following criteria:
I have for the third column labeled
Gaps. In this column I am trying to find a formula that calculates the difference between Desired and Current (Desired - Current). The problem I am running into is for the formula to assign a value to the criteria so the result is a number. So from the criteria mentioned earlier the values would go 6,5,4,3,2,1,0 in the same order. I have tried using VLOOKUP and INDEX/MATCH formulas but kept getting INVALID Ref.
Help Article Resources
Check out the Formula Handbook template!