LookUp Function

[ermengard]

Please help me with my table. I want to segregate each entry in the master table list to another table.
I hope anyone can help me figure out the formula for this. VBA is okay. Thanks in advance.

Attached here is my spreadsheet. TABLE_CONTRIBUTIONS.xls

[azumi]

Pls check this out, all using array formula, means when ENTER this formula you need to confirm press CTRL+SHIFT+ENTER button together, and then you can copied down or cross)

Cheers

[ermengard]

Thanks azumi.