Thanks Noob & Steve.

What I had was, in cell B2, I was extracting a process value, using a
formula, from another application, using an addin.

The value in that cell, for example would be a 1. Which is a logic true
value, simply stating that a silo is selected (1=Selected, 0=Not
Selected).

I had a formula in the ajacent cell C2 *=If(B2,=1,"1","") *which means
that if the cell has a 1, then be 18 (which would be silo 18).

Well from B2:B20 are silo's 1-18. Only one silo can be selected at a
time. So what I was looking for was a formula that would look down
C2:C20 and pick out the only value that was there. The other cells
would be a 0.

I couldn't get your formula to work Steve.
What I ended up with was changing the above formula from what you see
to *=If(B2=1,1,0). *At the bottom of the range I have *=sum(C2:C20),
*and I get the value that I need.

Sorry I wasn't clear in the beginning. I'll be glad to look at any
other solution that you may have. :)

Thanks a bunch again,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=553291