View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
not really sure about your data layout. Could you provide some example
rows of your data and your expected result?

--
Regards
Frank Kabel
Frankfurt, Germany


TLK40us wrote:
I have a YTD spread sheet that I'm building using a VlookUp table.
The LookUp table is built from a cell referenced worksheet from an
AS/400 static spreadsheet. Each week this I download the AS/400
information then copy and special paste sheet to the cell referenced
worksheet. This information is feeds up to the YTD sheet that
provides trend data for the year. By entering the next Week number
how do I build a dynamic VlookUp column that by entering a the week
number the data will dynamically populate the next column builidng to
the prior weeks YTD spreadsheet.