software

I've got a Worksheet W/Pincodes: Collumn A(Pin Codes) and Column N(SSN)
In another Worksheet W/O Pincodes: I have Column O(SSN)
I need to Compare the Two collums from W/Pincodes to the Collumn in W/O
Pincodes and insert Pincodes to this Worksheet associated to the SSN.

Hope this make sense any help is much appreciated!

in the ws w/o pincodes:
=INDEX(Sheet1!A:A,MATCH(O1,Sheet1!N:N,0))
and fill down

quot;Jayquot; wrote:

gt; I've got a Worksheet W/Pincodes: Collumn A(Pin Codes) and Column N(SSN)
gt; In another Worksheet W/O Pincodes: I have Column O(SSN)
gt; I need to Compare the Two collums from W/Pincodes to the Collumn in W/O
gt; Pincodes and insert Pincodes to this Worksheet associated to the SSN.
gt;
gt; Hope this make sense any help is much appreciated!

Assuming 1st Worksheet(W Pincodes) is named Sheet1,
In second worksheet(W/O Pincodes), insert formula:

=INDEX(Sheet1!A:A,MATCH(O1,Sheet1!N:N,0),1)

HTH
--
AP

quot;Jayquot; gt; a écrit dans le message de news:
...
gt; I've got a Worksheet W/Pincodes: Collumn A(Pin Codes) and Column N(SSN)
gt; In another Worksheet W/O Pincodes: I have Column O(SSN)
gt; I need to Compare the Two collums from W/Pincodes to the Collumn in W/O
gt; Pincodes and insert Pincodes to this Worksheet associated to the SSN.
gt;
gt; Hope this make sense any help is much appreciated!