I have the following formulas in I2 and I3 respectively":

=IF(H2='functions DO NOT DELETE'!A:A,'functions DO NOT DELETE'!B:B,"nothing")
=IF(H3='functions DO NOT DELETE'!A:A,'functions DO NOT DELETE'!B:B,"nothing")

Both cells H2 and H3 contain the word "Manager". Both should contain the same result. The formula in I2 works and comes back with the correct result from the worksheet "functions DO NOT DELETE', but the second one, I3, along with all consecutive ones in the column, come back with the result "nothing" even though they should have the same result. Why does the first formula work but none of the rest?

Changing the formula to !A$1:A$30 and !B$1:B$30 does not change the result.