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!

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