S
SB_2009
I have a list of data that is refreshed from a system and i wish to use the
text returned in each cell as the named range reference in a vlookup so that
i can fill down the formula against the full list.
For example:
Cell Text in cell Deesired Formula
A1 Yellow = vlookup(c1,Yellow,2,false)
A2 Red = vlookup(c2,Red,2,false)
A3 Blue = vlookup(c2,Blue,2,false)
But using the text in the cell as the named range e.g =vlookup(c1,a1,2,false)
Is there anyway to do this?
text returned in each cell as the named range reference in a vlookup so that
i can fill down the formula against the full list.
For example:
Cell Text in cell Deesired Formula
A1 Yellow = vlookup(c1,Yellow,2,false)
A2 Red = vlookup(c2,Red,2,false)
A3 Blue = vlookup(c2,Blue,2,false)
But using the text in the cell as the named range e.g =vlookup(c1,a1,2,false)
Is there anyway to do this?