| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dynamic Column VlookUps Based on Week Number
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
| GradeBook | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
