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

  • Thread starter Thread starter devo.uk
  • Start date Start date
D

devo.uk

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
 
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
Click to expand...

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...
Click to expand...

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"), ...)

---
 
Back
Top