Hi

I need to automatically populate a colum in a table with values from a
separate sheet.

e.g. in table 1, I have column headings:
Date; Type; Value 1... (also trying to lookup with new column)

In table two I have:
Date; Value 2

Where the date matches I would like to populate table 1 with Value 2. The
problem I am having is that there are three different 'types' for each date
in table 1.

Could someone please help?