| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help - subtotal using vlookup depending on variable month
Hi All,
I'm trying to find a value from table A in table B using vlookup and then sum the months YTD depending on the month. So for example if I enter April or 4 table A Month__4___<---value entered manually name $ytd bob 142 mob 117 gob 152 table b PC Jan Feb Mar Apr May Jun Jul..........Dec bob 22 50 45 25 56 78 89 12 mob 32 25 25 35 52 85 24 15 gob 32 20 15 85 95 65 45 85 Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUM of column values depending on the heading (month) | Excel Discussion (Misc queries) | |||
| How do I sort between worksheets depending on variable | Excel Worksheet Functions | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| Reading Data from another workbook... depending on variable in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
