Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP specific data for month required via dropdown list
I may have already posted this but I couldn't find my question!! Anyway, I
have created a drop down list of months in order to capture monthly accounting data. March is the 2nd month in my accounting year and is located in column 2 of my table. I then created the following VLOOKUP formula which gets the data I want. =VLOOKUP('Money & Budgets'!D96,'Money & Budgets'!$D$95:$R$138,3,FALSE) Question. How should I write the formula so that if I change the drop down list to April the VLOOKUP formula automatically changes to look in column 4 for the data instead of column 3. May should select column 5, etc. I have been at this for hours, days and nights and just can't get my head around it. Please help. Thanks Toni |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data in a list that meets a specific criteria | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
How to validate data in already list dropdown validated. | Excel Discussion (Misc queries) | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) |