Hi!

I need cell A1 to be equal to Cell B35.
i now need A1 to equal C72

So, which is it? A1 to equal column B or A1 to equal column C?

This is for column B:

=INDEX(B1:B100,MATCH(1,C1:C100,0))

Biff

"flyingmeatball"
<flyingmeatball.2cakru_1155159087.2904@excelforu m-nospam.com wrote in
message news:flyingmeatball.2cakru_1155159087.2904@excelfo rum-nospam.com...

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