Wildcard Search in Excel

[Bryn Needs Help]

Hi

Am using a Wildcard Search in an Xlookup

=Xlookup(”*”&A1&”*”,B5:B199,C5:C199,,2)

Works fine if the lookup cell contains a value, when the Lookup cell does not contain a value matches with first cell to contain a space anywhere, cannot work out a way to stop this behaviour,

Does anyone have any ideas??????

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(A1="","",XLOOKUP("*"&A1&"*",B5:B199,C5:C199,,2))

 

[Bryn Needs Help]

Hi & welcome to MrExcel.
How about

=IF(A1="","",XLOOKUP("*"&A1&"*",B5:B199,C5:C199,,2))

Thank you for the welcome and solution, could not see the wood for the trees

 

[Fluff]

You're welcome & thanks for the feedback.