Exact match for =if(isnumber(find ???

you may need to use a lookup
for example
trapiche syrah reserve
does not have
Shiraz anywhere in the name, so a search would not work

how long is the list and possible lookup table

I dont think you can look for Shiraz on its own , as that would be grouped together

But please do not post images, otherwise someone may need to create the spreadsheet - which maybe a lot of work, and put some members off
instead
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.