If two cells match return a value from a third column to the same row where the cells matched
<p>I have three columns A, B, C.</p>

<p>Column A: 2,500 names
Column B: 150 Zones
Column C: 150 names associated with specific zones</p>

<p>What I want to is, if a name in column C matches a name in column A, the value that should be returned is the Zone that is associated with the name in column C that matched the name in column A, but this value should be returned in the same row (of a new column D) as the name that matched in column A.</p>

<p>For example, suppose that C2 matched A1000, so the value that should be returned is B2 to D1000</p>

<p>I've tried <code>=INDEX(B:B, MATCH(C1,A:A,0))</code> but the value returned from this function is either not returned in the same row as A, or is returning the wrong value to the row that matched. What I want to is to return the value from B that is in the same row of the name of C that matched a name on A, but it has to be returned in the same row of A that matched.</p>