Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH OFFSET LIST VALIDATION
Okay I have looked over contextures for how to do this. I know the answer is
there, but I cant figure it out, will someone please show me how to do this without VB code. Please! I want to use match and the offset command, I want to name a range of data and pop it into a list validation cell. Sheet1 will have a list validation box referencing a range name Sheet2 has two columns of data ColumnA ColumnB TV 1.0 Camera 2.0 I want the list validation box to show column a, and then when I choose tv it pops column's b value in the cell. Please help me! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH OFFSET LIST VALIDATION
Hello Kenny
With defined names ColA for values in column A and ColB for values in column B, and validation list in cell D2, formula in D3: =INDEX(ColB,MATCH(D2,ColA,0)) HTH Cordially Pascal "Kenny" a écrit dans le message de news: ... Okay I have looked over contextures for how to do this. I know the answer is there, but I cant figure it out, will someone please show me how to do this without VB code. Please! I want to use match and the offset command, I want to name a range of data and pop it into a list validation cell. Sheet1 will have a list validation box referencing a range name Sheet2 has two columns of data ColumnA ColumnB TV 1.0 Camera 2.0 I want the list validation box to show column a, and then when I choose tv it pops column's b value in the cell. Please help me! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH OFFSET LIST VALIDATION
Thanks papou, but this is not what I am needing. I need the info in one cell.
In your example below there should be no d3. I want d2 to contain the list drop down, when you click on the drop down it will show colA, but when I click on a choice it will populate d2 with the data in colB. The drop down shows colA, but then populates colB in same cell d2. Please help thanks "papou" wrote: Hello Kenny With defined names ColA for values in column A and ColB for values in column B, and validation list in cell D2, formula in D3: =INDEX(ColB,MATCH(D2,ColA,0)) HTH Cordially Pascal "Kenny" a écrit dans le message de news: ... Okay I have looked over contextures for how to do this. I know the answer is there, but I cant figure it out, will someone please show me how to do this without VB code. Please! I want to use match and the offset command, I want to name a range of data and pop it into a list validation cell. Sheet1 will have a list validation box referencing a range name Sheet2 has two columns of data ColumnA ColumnB TV 1.0 Camera 2.0 I want the list validation box to show column a, and then when I choose tv it pops column's b value in the cell. Please help me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Offset by more than one value | Excel Discussion (Misc queries) | |||
Match Value and then offset | Excel Worksheet Functions | |||
MATCH and OFFSET | Excel Worksheet Functions | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions | |||
Using MAX with OFFSET and MATCH | Excel Worksheet Functions |