|The INDIRECT function should work for you. The INDIRECT function changes a text string to a reference.|
This will reference Mike!B(whatever "row number" is in C1)
=INDIRECT("MIKE!$B$" & C1)
Note the use of the quotes around MIKE!$B$. That tells the INDIRECT function that it is a text string. The C1 is not enclosed in quotes, so Excel uses that as a cell reference.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03