combining values and text to make a reference for "named range"
 

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

combining values and text to make a reference for "named range"
 

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

With DV assumed in A1,
you could have in B1: ="Grid"&A1&"_DropMetric"

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...

Use INDIRECT to wrap B1 in the expressions,
eg something like this: =INDEX(INDIRECT(B1), ...)

Or, you could away with B1, and directly point to the DV cell A1:
=INDEX(INDIRECT(="Grid"&A1&"_DropMetric"), ...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

combining values and text to make a reference for "named range"
 

Typos, corrected, should read:
Or, you could do away with B1, and directly point to the DV cell A1:
=INDEX(INDIRECT("Grid"&A1&"_DropMetric"), ...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

combining values and text to make a reference for "named range
 

max ..
many thanks
!

combining values and text to make a reference for "named range
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"devo.uk" wrote in message
...
max ..
many thanks !