View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc[_7_] Marc[_7_] is offline
external usenet poster
 
Posts: 1
Default Populating Pageheaders Using Vertical Lookups

I have a data table with dates in it. I need to populate
the page header using a lookup table. For Example:

Date: feb

Table with dates:
Jan 01/01/03
feb 02/01/03
apr
may

Data Table
Code:
001
002
003
004 1/1/03 02/01/03 03/01/03

For Example, I want to look up code 004 to get the date
listed as Feb in the table with dates and stick it in a
page header.