Vlookup - multiple returns

[surfsup00]

I've found numerous answers to this questions but failed to get any to work



I have

Worksheet - RAW

A second sowrksheet called - Payments


RAW

Has an ID column and a name

A	B
ID	NAME
1	Dave
2	Jim
3	Sam

PAYMENTS has matching ID column, with payment column and date column
There can be more than one payment in PAYMENTS with the same id

A	B
ID	Amount
1	22
2	1233
3	34
1	23

I want to show in RAW

ID	NAME	P1	P2
1	Dave	22	23

[Pepe Le Mokko]

Hi
hae a look at http://fiveminutelessons.com/learn-m...le-values-list