Named range in cell reference

[KGee]

This should be simple but I can't get the right syntax. I need to figure out the last row in column B and parse a string value from the text in that cell. I created a named range (dcLastRow) to return the last row (132 in current report) and want to use that named range within my cell formula. I've tried different variations of the syntax below but nothing is returned or I get a #name error.

=MID("B" & dcLastRow,6,3)

 

[mikerickson]

=MID(INDEX(B:B, dcLastRow, 1), 6,3) is less volatile than the INDIRECT approach.

 

[KGee]

Thanks so much guys. These all worked. I need to extract additional values from that cell but now that I have the key I can take it from here. What is the difference, if any, from the two formulas below?

[COLOR=#333333]=MID(INDEX(B:B,dcLastRow),6,3)
[/COLOR][COLOR=#333333]=MID(INDEX(B:B,dcLastRow,1),6,3)[/COLOR]

 

[mikerickson]

The first one uses the default 1 as the second argument. I prefer explicitly declaring optional defaults, as in the second.