Vlookup reverse lookup

[konquistador]

I have two columns :ColA(Pol_Number) and ColB(Zip Code) in one spreadsheet(colB is blank). I have another spreadsheet in which there are all the values. I have to lookup all the values from colA(Pol_number) from spreadsheet 1 in ColC(from spreadsheet 2) and then for all the matching values bring in the ColD(zip code from Spreadsheet 2) to the ColB(in the first spreadsheet).

Spreadsheet1:
ColA_______________ColB
Policy_Number___ Zip Code(needs to be populated)

Spreadsheet2:
ColC_______________ColD
Policy_Number___ Zip Code(values are here)


Please Advise,

thanks,
kon

[NBVC]

Use Index/Match

e.g.

=Index('SpreadSheet 2'!B:B,Match(A2,'Spreadsheet 2'!C:C,0)

adjust ranges and sheetnames to suit. A2 is your lookup value...

[konquistador]

Awesome....thanks a lot.