| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i use the text in a cell as a named range in a vlookup form
Say we have a table from I2 thru J4:
1 rose 2 bud 3 tree and we assign the Name plant to the table. say we enter 2 in A1 and plant in A2. =VLOOKUP(A1,I2:J4,2) =VLOOKUP(A1,plant,2) =VLOOKUP(A1,INDIRECT(A2),2) will all work and all return bud. So as long as the proper Table Name gets in A2 you can use it in the VLOOKUP() -- Gary''s Student - gsnu200832 "SB_2009" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i use the text in a cell as a named range in a vlookup
Brilliant - that works exactly as i wanted.
Cheers! "Gary''s Student" wrote: Say we have a table from I2 thru J4: 1 rose 2 bud 3 tree and we assign the Name plant to the table. say we enter 2 in A1 and plant in A2. =VLOOKUP(A1,I2:J4,2) =VLOOKUP(A1,plant,2) =VLOOKUP(A1,INDIRECT(A2),2) will all work and all return bud. So as long as the proper Table Name gets in A2 you can use it in the VLOOKUP() -- Gary''s Student - gsnu200832 "SB_2009" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
