Use Index to get range
 

I have a dget function that I want to use different range and criteria ranges
depending on a flag. I thought that index would work but I am getting a
value error. Thanks in advance for any help.

Here's the formula:

=dget(index(rangearray,1),az11,index(rangearray,3) )

whrere
Med1_602
Med2_602
Med1_602Crit
Med2_602

are a range called rangearray

If I do the index function independently it gives me the correct range but
in the dget formula I get an error?

Use Index to get range
 

Is DGet expecting a range? INDEX will return a value which is passed to
DGet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
I have a dget function that I want to use different range and criteria
ranges
depending on a flag. I thought that index would work but I am getting a
value error. Thanks in advance for any help.

Here's the formula:

=dget(index(rangearray,1),az11,index(rangearray,3) )

whrere
Med1_602
Med2_602
Med1_602Crit
Med2_602

are a range called rangearray

If I do the index function independently it gives me the correct range but
in the dget formula I get an error?

Use Index to get range
 

Yes dget is expecting a range, the range name I want is Med1_602.

"Bob Phillips" wrote:

Is DGet expecting a range? INDEX will return a value which is passed to
DGet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
I have a dget function that I want to use different range and criteria
ranges
depending on a flag. I thought that index would work but I am getting a
value error. Thanks in advance for any help.

Here's the formula:

=dget(index(rangearray,1),az11,index(rangearray,3) )

whrere
Med1_602
Med2_602
Med1_602Crit
Med2_602

are a range called rangearray

If I do the index function independently it gives me the correct range but
in the dget formula I get an error?

Use Index to get range
 

Not getting it, is Med602 a value, or is it supposed to be a range? In other
words, are you trying to INDEX into a range to get a range to pass to DGET?


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
Yes dget is expecting a range, the range name I want is Med1_602.

"Bob Phillips" wrote:

Is DGet expecting a range? INDEX will return a value which is passed to
DGet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
I have a dget function that I want to use different range and criteria
ranges
depending on a flag. I thought that index would work but I am getting
a
value error. Thanks in advance for any help.

Here's the formula:

=dget(index(rangearray,1),az11,index(rangearray,3) )

whrere
Med1_602
Med2_602
Med1_602Crit
Med2_602

are a range called rangearray

If I do the index function independently it gives me the correct range
but
in the dget formula I get an error?

Use Index to get range
 

Yes exactly, Med1_602 is a range.

"Bob Phillips" wrote:

Not getting it, is Med602 a value, or is it supposed to be a range? In other
words, are you trying to INDEX into a range to get a range to pass to DGET?


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
Yes dget is expecting a range, the range name I want is Med1_602.

"Bob Phillips" wrote:

Is DGet expecting a range? INDEX will return a value which is passed to
DGet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adella" wrote in message
...
I have a dget function that I want to use different range and criteria
ranges
depending on a flag. I thought that index would work but I am getting
a
value error. Thanks in advance for any help.

Here's the formula:

=dget(index(rangearray,1),az11,index(rangearray,3) )

whrere
Med1_602
Med2_602
Med1_602Crit
Med2_602

are a range called rangearray

If I do the index function independently it gives me the correct range
but
in the dget formula I get an error?