Function to pull a single cell from a column into another cell

[LukeShep]

This is probably just a simple function, but i don't know what it is.
have a column of information that is being pulled from an adjacen
column where only 1 cell will have anything in it but 0. I need to pul
whatever cell in the columns information to a single cell somewher
else. Is there a function for this? thanks in advance new here..

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[zvkmpw]

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))