VLookUp alternative

Hello,

I have a spreadsheet with a list of customers who need to receive a notification letter. Some customers have the same name, but they each have a unique ID number. Unfortunately, their mailing addresses reside in a separate spreadsheet - intertwined with all customers, not just those who need the letter.

I want to use their unique client ID numbers to look up the address from the giant spreadsheet and match them to the address field on the mailing list. I tried VLookUp, but could not batch apply the formula to entire columns. What strategy would you recommend for this?

Thanks for your time,