View Single Post
 
Old 03-05-2018, 06:12 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Assuming you enter the formula starting in say, K7, try:

=IFERROR(INDEX($E$8:$E$28,MATCH(1, IF($E$8:$E$28<>"(Must Choose)",IF($E$8:$E$28<>"",IF(ISNA(MATCH($E$8:$E$2 8,K$6:K6,0)),1))),0)),"")

change the range K$6:K6 to match cell above where you enter formula.

Then confirm the formula with CTRL+SHIFT+ENTER to make it an Array formula, then copy it down.
Reply With Quote