Hi

Let's say I have this formula in A1:

=if(A2=2,"Hello","")

But let's say I want to make the location of where the '2' has to be to
trigger the 'Hello' in A1 conditioned on a value in B1, and let's say B1
changes to 5. So now instead of the formula in A1 saying
=if(A2=2,"Hello","") I will want it to say =if(A5=2,"Hello","").

Many thanks as always

tx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=519578