Index / Match vLookUp functions question

[Guest]

Frank

I have used you recommendation to use the VLookUp function. However, I am only picking up one instance of the the record number from the DataIssues sheet: =VLOOKUP(A4,'EventList'!$A$10$M$310,2,0

Example: "General Data" product numbers are = 321, 222, 111, 255, 521

The “Data Issues†sheet contains: 321 a, 321 b, 321 c / 222 a, 222 b, 222 c, 222 d, 222 e / 111 a / 255 a, 255 b / 521 a, 521 b, 521 c

The numeric values are in column (A), the alpha characters are in column (B) for simplicity on the “Data Issues†shee

On the “DataResults†sheet I need to end up with: GD (A) DR (A) (B
321 321
321
321
222 222
222
222
222
222
111 111
225 255
255
521 521
521
521

GD = General Data Sheet, DR = DataResults Sheet combining "Data Issues" records with the General Data records. Is this possible

Thanks,.................

 

[Frank Kabel]

Hi Terry
for this output result I would try to use a pivot table using both of
your columns as rows in the pivot table report and the counof one
column as data source.
For more information on pivot tables have a look at:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm

Frank