Excel Help Please

Synkro

Hi, would anybody know of a way to do this...

I have 2 excel sheets

The first Sheet, lists the shoppers names (columnB)and a Shopper_id(columnA)

The Second Sheet, lists the Shopper_id (ColumnA) and on the same row, their purchase (ColumnB)



I basicaly have 2 sheets and 3 variables. The common link between the variables is the 'Shopper_Id'.

On a new sheet I need the 'Shopper_Id' in columnA with corresponding 'Name' in ColumnB BUT most importantly i need each shoppers purhase in the third column.

Also where multiple items have been purchased by one client i would like to have them separated by either a comma or CR.

Like this....




Could anybody suggest a way to do this?


Thanks!
Adrian

Gosh

Adrian - if you're familiar with creating EXCEL macros then PM me and I mighr be able to help you

Synkro

I found this command which almost works...

VLookup

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)


I entered

=VLOOKUP(A2,'Shopper_ID & Purchases'!A2:B18,2)

into cell C2 on the 'Shopper_ID & Purchases' sheet.

It searches the 'Shopper_ID & Purchases (sheet2)' sheet for the Shopper_Id value specified in cell A2 of the 'Shopper_ID & Name & Purchases (sheet3)' sheet. If it matches it returns the value in Column 2.

The only problem is.... it only returns the last purchase. ie. the final match.

This is the result....



Anyone have anyideas?

CtrlSource

I never figured Henry as a "strawberries & custard" kinda guy

Different strokes....