Searching a cell range for specific text from another cell

Hi guys,

I need to search a cell for a specific text from another cell and return the column number. This is the code I have;

Please Login or Register  to view this content.

I want to make it some thing like the following so that I just have to change one cell. The range of cells I am searching look like "FV-D2 28/09/2019" so when I use the following it doesn't work.

Please Login or Register  to view this content.

[/CODE]

Any Ideas?

Thanks in advance,
Calum

enter the below in A2
*FV-D2*
and use your formula as

Please Login or Register  to view this content.

It is working for me, if it is not working attach a sample excel file

Looks to me like it should work, DEPENDING on if what you are searching for is EXACTLY what typed.

If Samba's suggestion doesnt work for upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.