"T. Valko" wrote in message
...
Try this:

=INDIRECT(B6&1)

Many thanks to all three of you for providing the solution so quickly.

I had tried the INDIRECT function earlier on but just couldn't get to the
simple formula you gave! Presumably the '&' in the formula is providing the
concatenate function?

V