multiple lookup formula

Hi all,

I'm brand new to the site, so please bear with me.

I've been banging my head on a brick wall for a while. I'm needing a formula to lookup a figure from multiple columns. I have highlighted in yellow on the spreadsheet where I need to look up - Name, Catagory & Total.

I hope this make sense??