| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i use the text in a cell as a named range in a vlookup form
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP with a Named Range argument | Excel Worksheet Functions | |||
| using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Vlookup in a named range | Excel Worksheet Functions | |||
Threaded Mode
