I'd like to use a reference to refer to a requirement number in a matrix I'm
building, for example I want to put '=A154' in a Reference column for a
requirement number 155 for example, so it will reference requirement number
154 which is the number in cell A154. But after I sort, that cell now holds
an entirely different number because A154 now holds some completely different
requirement. I've tried using '=A$154', but that has the same result. I
don't want to just type the requirement number in because I may change the
requirement numbers and I want the references to automatically update if I
change the requirement numbers.