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...