ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple columns applied with one picklist (https://www.excelbanter.com/excel-worksheet-functions/226178-multiple-columns-applied-one-picklist.html)

SKYDEX

multiple columns applied with one picklist
 
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

Francis

multiple columns applied with one picklist
 
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



All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com