Any order searches in Excel

[khanram]

Hi,


I just want to know if it is possible to search data in Excel in any order.


For instance, in cell A1, I have the product "10 mm Clear Saudia". If I hit Control + F, I have to search for "Saudia" or "Clear" or "Clear Saudia" to find the product.

I was wondering if there is a way if I type "Saudia Clear" and it would still find the product for me. This is because most of the time I do not remember the exact product names but do remember certain key words related to the product. Most of the time I can't find the product details because I can't type in the details in the correct order.

Is there anyway to get around this?


Any help would be greatly appreciated.


Thanks,
Ram

 

[Aladin Akyurek]

Correction to VLOOKUP...

=VLOOKUP("*"&D2&"*",$A$2:$B$14074,2,0)