Hi all

I have a spreadsheet with a named range called
Grid89_DropMetric, and Grid89_WidthMetric, Grid127_DropMetric and
Grid127_DropMetric

I have a dropdown that select either 89 or 127 and want to create a cell
which builds up the grid an add the cell value and then add ons the
dropmetric or widthmetric on the end of it.. so it creates a string name

then i want to refer to that cell in other index and match functions as
"Range Name" but dont know if it can be done...

Trying to avoid vba at the moment .. is there anyway i can get the string
and then use it as an applied name for a range

thanks