View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Help with lookup

Hi,
could you provide an example

"CW" wrote:

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?