| 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! |
| 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 | |||
Threaded Mode
