You should be able to do that more simply with LOOKUP as per my suggestion

=LOOKUP(9.99E+307,'sheet 2'!7:7)