Hi,
I have a price list containing over 10000 items with descriptions, catalogue no, unit and etc. spreading from column A to D. Now I have received an inquiry for 300 items and it's a headache to search for each item through my price list and copy every detail. Also, while there might be several occurrences of one item (for example different compounds of one material or different packaging) and i want all occurrences to be offered to the customer, so that they can make a well informed decision, I can not use VLOOKUP function, while it only returns the first item it finds.
So basically I need a code to look for items listed in a specific column (say F) in my price list (columns A to D) and when it finds the item (or multiple items), it returns all the information listed in columns A to D relating to the item, in a new table, say in Sheet 2. The code must search column B for the data listed in column F. It would be helpful to have the row no. of each found item too.
Thanks in advance
I have a price list containing over 10000 items with descriptions, catalogue no, unit and etc. spreading from column A to D. Now I have received an inquiry for 300 items and it's a headache to search for each item through my price list and copy every detail. Also, while there might be several occurrences of one item (for example different compounds of one material or different packaging) and i want all occurrences to be offered to the customer, so that they can make a well informed decision, I can not use VLOOKUP function, while it only returns the first item it finds.
So basically I need a code to look for items listed in a specific column (say F) in my price list (columns A to D) and when it finds the item (or multiple items), it returns all the information listed in columns A to D relating to the item, in a new table, say in Sheet 2. The code must search column B for the data listed in column F. It would be helpful to have the row no. of each found item too.
Thanks in advance