The function I am trying to figure out is this:

=IF(ISBLANK(E2),"",IF(N2<2,"Next" <here if N2 is <2 show contents
from cell G1)))

I want to show contents from cell G1 to the above function, how do I
do this?

Thanks,
Rube