Combine two Tables, both have account numbers

[rbarr]

I have two sheets, both sheets have the client account numbers, but one has the phone, email and name, and the other has the name and address. I need to add the address to the sheet with the phone and email. There are other a thousand records so doing this manually is not ideal.

Can someone give me an idea of how to do this, or even just the function name?

Thanks,

Robb

 

[Truiz]

There is the simple VLOOKUP or the more robust and ideal combination of INDEX and MATCH