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