Could it search for "Delicious Orange" as an entire phrase?

Yes of course. If it is as an entire phrase, then my original response
should have worked. You might want to fortify it a bit more by using TRIM
around A1, since the search string (the entire phrase) now contains a single
space:
=INDEX(B$1:B$3,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($B $1:$B$3,TRIM(A1))),),0))

If this response helped in any way, do press the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---