I have the following formula below where I cannot get the section containing the Wildcard to work
]code] JNL!"*"&Z1&"*" [/code]
It would be appreciated if someone could amend my code
]code] JNL!"*"&Z1&"*" [/code]
Code:
=INDEX('Pivot Table'!D1:D20,MATCH(JNL!"*"&Z1&"*",'Pivot Table'!A:A,0))
It would be appreciated if someone could amend my code