Thread: [Solved] Drop-down menu in Excel, filling up the lists according to selection
View Single Post
 
Old 01-18-2017, 08:04 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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&"."
Reply With Quote