Loss1003
11-20-2018, 11:05 AM
Currently using: =IFERROR(INDEX($D$2:$D$10000,MATCH(1,(G24=$G$2:$G$10000)*($Q$1=$D$2:$D$1000 0),0)),"")
However, I need to add a wildcard to pickup partical text match in column D based on cell value $Q$1 or "Civil".
I Tried adding &"*" but it did not work.
IFERROR(INDEX($D$2:$D$10000,MATCH(1,(G24=$G$2:$G$10000)*($Q$1&"*"=$D$2:$D$10000),0)),"")
Any assistance is greatly appreciated.
However, I need to add a wildcard to pickup partical text match in column D based on cell value $Q$1 or "Civil".
I Tried adding &"*" but it did not work.
IFERROR(INDEX($D$2:$D$10000,MATCH(1,(G24=$G$2:$G$10000)*($Q$1&"*"=$D$2:$D$10000),0)),"")
Any assistance is greatly appreciated.