A
Adella
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 in a range called rangearray. These are all ranges that I want to use
in the dget formula depending on other criteria.
If I do the index function independently it gives me the correct range but
in the dget formula I get an error?
Thanks, I posted this last week on the function area, but didn't receive a
solution, hoping someone here know one.
Thanks in advance for any help.
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 in a range called rangearray. These are all ranges that I want to use
in the dget formula depending on other criteria.
If I do the index function independently it gives me the correct range but
in the dget formula I get an error?
Thanks, I posted this last week on the function area, but didn't receive a
solution, hoping someone here know one.
Thanks in advance for any help.