grichey
05-29-2009, 07:21 AM
Let's say I have the following
vlookup($A5,$A$1:$D$10,2,0)
This formula is useless out past column D. Is there a way to make the D in the array dynanmic? I tried using $A$1:column(cellaboveformula)10 but that doesn't work.
I could just make the array that it's looking through out to column BB or some other long ways out there column that I'm sure not to use but I'm wondering if it's possible to do what I'm talking about.
Thanks for the help.
vlookup($A5,$A$1:$D$10,2,0)
This formula is useless out past column D. Is there a way to make the D in the array dynanmic? I tried using $A$1:column(cellaboveformula)10 but that doesn't work.
I could just make the array that it's looking through out to column BB or some other long ways out there column that I'm sure not to use but I'm wondering if it's possible to do what I'm talking about.
Thanks for the help.