Search index match

Status
Not open for further replies.

Bibinp

New Member
Joined
Jan 4, 2018
Messages
5
[FONT=&quot]I am very newbie in excel, I need a formula for searching a word and reuturn it’s match items and values.
I have a master data sheet, heading with Item code, Item Name, Qty, Price and it’s Catogory.

In my working sheet I have only item code and item name
I insert a search key column after the item name.

When I enter a word or phrase in a search key colum, that word need to search in item name column and find and match similar items with it’s value from master data sheet and return all matched items in my worksheet with sort by item catogory wise.
can u help me please, thanks in advance
Example

worksheet
item code item name Search key
123 Apple USA App
124 Orangeuk. Ora
6772 M.Water 500. (Blank)
1234 Apple Ind. ind

Master data

item code item name. qty price cat.
12525 Tissue. 12 1.3 23
124 Orangeuk. 5 1.2 12
123 Apple USA 16 1.7 13
6772 M.water 500 2 1.0 18
[/FONT]
[FONT=&quot]1234 Apple Ind. 5 1.7 13[/FONT][FONT=&quot]

the result
[/FONT]
[FONT=&quot]item code item name. qty price cat.

[/FONT]
[FONT=&quot]124 Orangeuk. 5 1.2 12[/FONT]
[FONT=&quot]123 Apple USA 16 1.7 13
[/FONT]
[FONT=&quot]1234 Apple Ind. 5 1.7 13
[/FONT]
[FONT=&quot]
[/FONT]
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Status
Not open for further replies.

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top