Hi,
I would like to do a wildcard word search to find all matches for a word entered from a list of descriptions, and if there are multiple occurrences of this word, I would like all matches displayed.
I have a worksheet called "Main"
In column "A" I would like to add a wildcard word search. (In attached example, the word is "value.")
I would like this entered word to be searched in column "K2"
Whenever the word "value" is found, I would like the full description found in K2 for the wildcard word matched or multiple matches populated in column "B2" (each separate description found is to be separated by a comma between them)
I would also like the corresponding data in J2 for the match or matches to populate to C2 in same way as above
I have this formula in the attached example, but it does not cover all the above. =IFERROR(INDEX($K$2:$K$57,MATCH("*"&A2&"*",$K$2:$K$57,0))," ")
Hope someone can help
I am using excel 365
I would like to do a wildcard word search to find all matches for a word entered from a list of descriptions, and if there are multiple occurrences of this word, I would like all matches displayed.
I have a worksheet called "Main"
In column "A" I would like to add a wildcard word search. (In attached example, the word is "value.")
I would like this entered word to be searched in column "K2"
Whenever the word "value" is found, I would like the full description found in K2 for the wildcard word matched or multiple matches populated in column "B2" (each separate description found is to be separated by a comma between them)
I would also like the corresponding data in J2 for the match or matches to populate to C2 in same way as above
I have this formula in the attached example, but it does not cover all the above. =IFERROR(INDEX($K$2:$K$57,MATCH("*"&A2&"*",$K$2:$K$57,0))," ")
Hope someone can help
I am using excel 365
| Book1.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | HS Code Description Wild card Description | HS code description | H.S Code | H.S Code | Raw materials | ||||||||
| 2 | Valve | Safety Releif valves | 73041100 | Steel Pipe / Carbon Steel Pipe | |||||||||
| 3 | 73041900 | Seamless - Steel Pipe / Carbon Steel Seamless Pipe | |||||||||||
| 4 | 73044100 | Stainless Steel Pipe | |||||||||||
| 5 | 73044900 | Stainless Steel Pipe / SS Seamless Pipe | |||||||||||
| 6 | 75071200 | Alloy Pipes | |||||||||||
| 7 | 73053100 | Welded Pipe / Carbon Steel Welded Pipe | |||||||||||
| 8 | 73061100 | Steel Welded Pipe | |||||||||||
| 9 | 73064000 | SS Welded Pipe | |||||||||||
| 10 | 73065000 | Alloy Welded Pipe | |||||||||||
| 11 | 73072100 | Flanges / SS Flanges | |||||||||||
| 12 | 73072300 | Pipe Fittings / Butt Weld Fittings | |||||||||||
| 13 | 73079300 | Butt Weld Fittings / Alloy Pipe Fittings | |||||||||||
| 14 | 73072900 | Pipe Fittings / SS Pipe Fittings/ SS & SDSS Forged Fittings | |||||||||||
| 15 | 73079900 | Alloy Pipe Fittings | |||||||||||
| 16 | 83111000 | Welding Consumables / Electrodes / Filler Wires | |||||||||||
| 17 | 72071200 | Semi-finished Products Of Iron Or Non-alloy Steel | |||||||||||
| 18 | 72082500 | Steel Plates / Flat-Rolled Products of Iron & Non Alloy Steel, Not Clad | |||||||||||
| 19 | 72199000 | Steel Plates / Flat-Rolled Products of Stainless Steel / SS Plates | |||||||||||
| 20 | 72161000 | Steel U Beams / I Beams / H Beams / Angles, Shapes & Sections Of Iron & Nonalloy Steel | |||||||||||
| 21 | 72191100 | Stainless Steel Plates / Flat-Roll Stainless Steel Products, Not Und 600mm Wide | |||||||||||
| 22 | 72254000 | Alloy Steel Plates / Flat-Roll Alloy Steel Nesoi N/Un 600mm Wide | |||||||||||
| 23 | 73079100 | Flanges / Steel Flanges | |||||||||||
| 24 | 73045900 | Stainless Steel Pipes / Alloy Pipes / Alloy Welded Pipes | |||||||||||
| 25 | 73063000 | Carbon Steel Welded Pipe | |||||||||||
| 26 | 73061900 | Carbon Steel Seamless Pipe | |||||||||||
| 27 | 73 | Stainless Steel Seamless Pipe | |||||||||||
| 28 | 84814000 | Safety Releif valves | |||||||||||
| 29 | 84818030 | Valves / Gate Valves / Globe Valves / Ball Valves | |||||||||||
| 30 | 84841000 | Gaskets Valves | |||||||||||
| 31 | 73051200 | Steel Pipe / Line Pipe of a kind used for oil or Gas pipelines | |||||||||||
| 32 | 73129010 | Steel Wire Rope / Slings / Cables / Antitwist Wire Rope | |||||||||||
| 33 | 72126000 | Steel Clad Plates / Flat Roll Iron & Steel with SS Clad | |||||||||||
| 34 | 72251900 | Alloy Clad Plates/ Flat Roll Iron & Steel with SS Clad | |||||||||||
| 35 | 85161010 | Heaters / Heater Coils | |||||||||||
| 36 | 84818090 | Control Valves | |||||||||||
| 37 | 84148000 | Screw compressor | |||||||||||
| 38 | 85015300 | AC motors / Mullti-phase of an output > 750 kW | |||||||||||
| 39 | 85372000 | Switchgear | |||||||||||
| 40 | 84138190 | Oil pump | |||||||||||
| 41 | 85015200 | AC motors / multi-phase, of an output > 750 W but <= 37 kW | |||||||||||
| 42 | 84212300 | Oil Filters | |||||||||||
| 43 | 84813000 | Check Valves | |||||||||||
| 44 | 84818070 | Strainers / Filtration Units | |||||||||||
| 45 | 85363000 | Electric Distribution Boards / Junction Boxes | |||||||||||
| 46 | 84219900 | Oil Filter Elements | |||||||||||
| 47 | 84836000 | Couplings Valve | |||||||||||
| 48 | 34039900 | Lubricating Oil | |||||||||||
| 49 | 85371000 | Programmable Logic Controllers / P L C | |||||||||||
| 50 | 73141400 | Demister Pads | |||||||||||
| 51 | 84818060 | Filtration Units / Strainers | |||||||||||
| 52 | 90259000 | Thermowells / Temperature Measuring Instruments | |||||||||||
| 53 | 84879000 | AV Mount | |||||||||||
| 54 | 84212990 | Coalescer | |||||||||||
| 55 | 84195000 | Heat Exchanger Units | |||||||||||
| 56 | 85444991 | Flame Retardant Cable | |||||||||||
| 57 | 84199000 | Description as Spare Parts / Machine Parts | |||||||||||
Main | |||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2 | B2 | =IFERROR(INDEX($K$2:$K$57,MATCH("*"&A2&"*",$K$2:$K$57,0))," ") |
| B3:B15 | B3 | =IFERROR(INDEX(#REF!,MATCH("*"&A3&"*",#REF!,0))," ") |
