Trying to do Vlookup on multiple columns from different worksheet
 

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!

Trying to do Vlookup on multiple columns from different worksheet
 

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!

Trying to do Vlookup on multiple columns from different worksheet
 

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!