Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a workbook with multiple wooksheets. On worksheet 1 F1 is a month/yr.
ie. Feb 08 (text). I want to do a Vlookup on E6 to sheet '2008 Budget' and sum columns up to column labeled Feb 08. Next month I will want the sum of Jan 08, Feb 08, Mar 08. etc. Each month adding a column to the sum. Looking at the following formula I want it to return the sum of B:M up to the column matching the value in F1. =VLOOKUP(E6,'2008 Budget'!$A$1:$M$105,('2008 Budget'!Sum(B5:C5)),FALSE) Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup on 2 columns | Excel Discussion (Misc queries) | |||
Vlookup from 2 columns | Excel Worksheet Functions | |||
VLookup against one of two columns | Excel Worksheet Functions | |||
Vlookup using two columns | Excel Worksheet Functions | |||
Vlookup with 2 columns | Excel Discussion (Misc queries) |