I download data from our database and it downloads as two tables which I can save as Excel worksheets. One table has the demographic info (name, address, etc). The other table might have our "contact" info (attendance at an event, letter we may have sent them, etc). I'm wanting to manipulate the data. In the past I've sent it into access but I thought it might be easier in excel.
The data in each table has a unique link field for each individual.
Someone mentioned that I could use VLookup as a way to get information from both tables.
I haven't a clue how to do it. Any advice?