I have three columns, A, B, & C. column C is empty, except for a 1 in a
single cell. I need to find a way to reference the cell next to the
cell in column C that has a 1. For example, Cell C35 currently has a
1, and all other C cells are empty. I need cell A1 to be equal to Cell
B35. However, i can't just reference it because the "1" in column C is
constantly moving. When I enter new date elsewhere the 1 may be in
C72, and i now need A1 to equal C72. Any ideas? Thanks in advance.


--
flyingmeatball
------------------------------------------------------------------------
flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302
View this thread: http://www.excelforum.com/showthread...hreadid=570144