& is used for concatenation.

=IF(B4=1,B1,if(B4=2,B2,if(B4=3,B3,"")))

But, you can alternately do:

=INDIRECT("B"&B4)

"dave glynn" wrote:

Cell C1 takes is value from any one of three other cells depending on the
value of cell B4. The if statement I should like to writr would go something
like this

if(b4=1,b1&if(b4=2,b2&if(b4=3,b3)))

Is this syntax correct?

Many thanks

Dave