I need help with this, please.
I have 3 columns comprising a data set:
A is a type identifier (eg. tap). There are multiple type identifiers, not sorted.
B and C contain data (description and price) that i want to extract into another table.
I want to extract all similar types (eg. tap) and their corresponding data in columns 2 and 3. Vlookup only returns the first row of data.
The idea being when i add a new tap to the bottom of the data set, it automatically gets added to the extracted table.
I have 3 columns comprising a data set:
A is a type identifier (eg. tap). There are multiple type identifiers, not sorted.
B and C contain data (description and price) that i want to extract into another table.
I want to extract all similar types (eg. tap) and their corresponding data in columns 2 and 3. Vlookup only returns the first row of data.
The idea being when i add a new tap to the bottom of the data set, it automatically gets added to the extracted table.