Match data and merge tables

Hi forum,
My scenario:

Table A has 360,000 records, table B has 400 records. They have uniquely matching data in column A.

Q: What is the best way to merge both tables into one table with only the 400 records from table B?

Thank you in advance for your help on this.

I think you need to give us a bit more detail about what data you have in which tables and where, and how you want to perform the merge, and you can best do this by attaching a sample Excel workbook. Take a look at the yellow banner at the top of the screen for details of how to do this.

Hope this helps.

Pete

I realize I'm supposed to provide visuals typically, but all info is proprietary.

I need all the record's data (the complete row) from each table.

I'm not sure what you mean by where, the records are in Table A and B.

There's no issue to replicate as I haven't tried anything yet. I simply don't know how to go about doing this task.

What kind of sample data would help you answer this question?

You told us that you have unique matching data in column A of both sheets, and that's all. Is table A in one sheet and B in another sheet, or are they both in the same sheet?

What columns of data do you have in both sheets?

How do you want to merge them? If you have numeric data, should these be added, or averaged, or do you want the latest value, or something else etc.? If you have dates should these show the earliest or latest date, or a date range, or most frequent date etc. etc. ?

If you have text values should these be joined together in some way, maybe separated by a comma?

If you have new records, should these be added to Table B, or do you just want existing records in table B to be updated?

These are the kind of details we need to have before being able to suggest a way forward. If you don't supply them, then how can we help you?

Hope this helps.

Pete

That's very helpful. Okay so what I have is numbers in column A of both tables (in separate sheets). The numbers will match, but all other data in both tables are unique so would all need to be added to one table without alteration. I'll make a sample set of tables and post in a minute.

Here is a sample of what I need.

You can put this in cell C2 of the Table B sheet:

=VLOOKUP(A2,'Table A'!A:B,2,0)

Copy it down if it doesn't do this automatically.

Hope this helps.

Pete

That worked great using false instead of zero and locking the range. Thank you so much!