Drop-down menu in Excel, filling up the lists according to selection

		Microsoft Office Forums > Microsoft Excel > Excel
Drop-down menu in Excel, filling up the lists according to selection

FAQ

Thread Tools

Display Modes

01-18-2017, 08:04 AM

xor

Windows 10 Drop-down menu in Excel, filling up the lists according to selection

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

Instead of putting "You must provide " and " beam" directly into the formula you can put the text you want in for example M4 and N4 and then use a formula like:

=$M4&" "&IF(ROWS($1:1)>COUNTA(K:K)-1,"",INDEX($K$4:$L$8,ROWS($1:1),MATCH($B$3,$K$3:$L $3,0)))&" "&$N4&"."

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with drop-down menu please	cazclocker	Excel	7	01-05-2015 04:07 PM
Auto text after selection from Dropdown menu	trainsy	Word	2	06-04-2014 04:43 AM
cannot get Office 2013 jump lists in Start Menu	pleveque	Office	0	10-07-2013 02:25 PM
Drop-down lists in Excel	Maureen	Excel	1	11-10-2011 08:11 AM
Ho to perform multi selection in drop down lists?	nashville	Word	0	09-29-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 PM.