I
have a column of information that is being pulled from an adjacent
column where only 1 cell will have anything in it but 0. I need to pull
whatever cell in the columns information to a single cell somewhere
else.

Suppose B is the column with only 1 cell will have anything in it but 0.

Suppose A is the column to pull information from.

If the non-zero cell in column B is always a positive number, then try:
=INDEX(A:A,MATCH(MAX(B:B),B:B,0))