Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm creating a quote form. There are three columns and multiple row. I want
to be able to create a picklist in the first column and have the associated columns also appear. How do I do this |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
there a few ways to do this depending on your data layout.
lookup VLOOKUP and Index..Match in the Help or post your sample and your expected result -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "SKYDEX" wrote: I'm creating a quote form. There are three columns and multiple row. I want to be able to create a picklist in the first column and have the associated columns also appear. How do I do this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink Picklist | New Users to Excel | |||
Batch Printing - filtered by Picklist | Excel Worksheet Functions | |||
MS Excel Validation picklist | Excel Discussion (Misc queries) | |||
multiple numeric values applied to single text | Excel Discussion (Misc queries) | |||
can autofilters be applied to rows rather than columns? | Excel Discussion (Misc queries) |