Hello all, I hope you can help with my problem

I have a table which looks a bit like this, imagine I had four sales areas, North, South East and West and 3 sales reps per area


1 Rep1 Rep2 Rep3 Area
2 John Mike Pete North
3 Sue Jane Mary East
4 Bill Steve Helen West
5 Jim Nina Keith South

(Sorry about the formatting, I'm not v good at this yet, hope you can read it)

What I would like to do is to be able to put anybodys name in a cell eg "Mary" and get Excel to return me the value "East" (ie the area where Mary works)

I've tried Vlookup, Match, Index etc until I'm losing my hair. The problem is trying to look up a value within a 2-dimensional table instead of just within a single row or column.

Sorry if this has been answered in an earlier thread, I couldn't find one.

Many thanks for all your help !