Excel Search Funtion

Hi

So i am creating a search function on excel, the problem I am having with it is that the contents of the excel is all formulas to bring information from a CSV file. i have brought the informaiton over ok and renamed a cell to use as a serch funtion but it is not doing the search because it is not recognizing the cells as text but rather formula.

Below is the foumla i am using to search the cells

=IF(ISBLANK(search_),0,SEARCH(search_,$A8&$B8&$C8&$D8))

any help is really appreciated

Thanks

Seamus

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

HI,

Thanks for your reply, I was unable to upload the documents but i have created links to them here if you are able to have a look and see what i am trying to achieve that would be really apreciated

https://www.dropbox.com/s/enceg4ngm7...COPY.xlsm?dl=0

https://www.dropbox.com/s/di39q22brk...-form.csv?dl=0

Please post files to this forum: follow instruction in post #2