[FONT="]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="]1234 Apple Ind. 5 1.7 13[/FONT][FONT="]
the result
[/FONT][FONT="]item code item name. qty price cat.
[/FONT][FONT="]124 Orangeuk. 5 1.2 12[/FONT]
[FONT="]123 Apple USA 16 1.7 13
[/FONT][FONT="]1234 Apple Ind. 5 1.7 13
[/FONT][FONT="]
[/FONT]
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="]1234 Apple Ind. 5 1.7 13[/FONT][FONT="]
the result
[/FONT][FONT="]item code item name. qty price cat.
[/FONT][FONT="]124 Orangeuk. 5 1.2 12[/FONT]
[FONT="]123 Apple USA 16 1.7 13
[/FONT][FONT="]1234 Apple Ind. 5 1.7 13
[/FONT][FONT="]
[/FONT]