Trying to do Vlookup on multiple columns from different worksheet

[Guest]

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!

 

[Guest]

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

 

[Ardus Petus]

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