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,

A pretty easy action with Power Query. Read the yellow banner at the top of this page.

Thanks for your reply, Alan. I'd be game for trying this, but management would have to approve the download. That might take a few days (and I'm on deadline).

Are there any alternatives, even if a bit more tedious than Power Query? I attached an abbreviated sample of the data. The real sheet has a few thousand rows.

Thank you,

Please try at B2
=VLOOKUP($A2,Database!$A$2:$F$99,COLUMNS($A2:B2),)

or
=INDEX(Database!B$2:B$99,MATCH($A2,Database!$A$2:$A$99,))