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

"Jay" wrote:

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!

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

"Jay" a écrit dans le message de news:
...
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!