vba how to match cell with range and return value in adjacent cells?
<p>Excuse my lack of coding language, I'm just getting into vba coding.
I have a list of Manufacturers (names) with contact details on one that I like to be populated on my "SPECSHEET" automatically when choosing manufacturer. </p>

<p>Worksheet "SPECSHEET" is fully created from macro.</p>

<p>Worksheet "CONTACTS" has a list of names in column A and phone numbers in column C</p>

<p>Worksheet "DATASHEET" holds information about each luminaire.</p>

<p>I am successful in showing the right manufacturer name:</p>

<pre><code>Worksheets("SPECSHEET").Cells(Company, 5).Value = Worksheets("DATASHEET").Cells(1, 5).Value
</code></pre>

<p>But I like the row below to show the phone number:</p>

<pre><code>If Worksheets("SPECSHEET").Cells(3, 4).Value = Worksheets("CONTACT").Range(A:A).Value Then
Worksheets("SPECSHEET").Cells(3, 5).Value = Worksheets("CONTACT").Cells(B "name adjacent to the matched name in column A) 
End If
</code></pre>

<p>Thanks for any help.</p>