Hi, I'm hoping someone can help me.

I need to match up some names to a master list, and collect the details and put them into another cell. My test spreadsheet is Charity Day.xlsx.

Basically, I need to match the name under the blue cells, to the name in columns A, B and C.
Then once found, I need to get their corresponding information and place them into the cells under the green headings.

I've done the first one manually as an example.

Any help would be fantastic! It doesn't matter if its a formula or macro. The version of excel this needs to work in will be 2003.

Many thanks!!