I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell. Drop down menu options in each cell are: Needs Contr…
Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'S…