Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I suggest that you post the spreadsheet (data changed) so that we can all have a look. You can use the 'Indirect' and 'Concatenate' commands to access cells. The following works =INDIRECT(CONCATENATE("B" &Place)). Place could be replaced with a number ending up with "B6", "Place" being a named cell.

All is possible......