Index Match with Wildcard

[howard]

I have the following formula below where I cannot get the section containing the Wildcard to work

]code] JNL!"*"&Z1&"*" [/code]

 =INDEX('Pivot Table'!D1:D20,MATCH(JNL!"*"&Z1&"*",'Pivot Table'!A:A,0))

It would be appreciated if someone could amend my code

 

[DanteAmor]

Try:

=INDEX('Pivot Table'!D1:D20,MATCH("*"&JNL!Z1&"*",'Pivot Table'!A1:A20,0))

 

[howard]

Thanks Dante-formula works perfectly