Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and Match combination
If I have months across the top and balance sheet items down the side and I
want to reference lets say Cash (A4) for Aug (column 7) this month but switch next Sep (column 8), I know that i can nest these two functions but it is not working properly. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and Match combination
Hi
Supposing your data is on Sheet1 and you have Months in B1:M1 and Items in A2:A100. On Sheet2 you have items in A2:A100 and you enter a Month in B1 the formula in B2 will be =INDEX(Sheet1!A$1:$M$100, MATCH($A2,Sheet!$A$1:$A$100,0),MATCH($B$1,Sheet1!$ B$1:$M$1,0)) Copy down column B as far as required -- Regards Roger Govier "ksal" wrote in message ... If I have months across the top and balance sheet items down the side and I want to reference lets say Cash (A4) for Aug (column 7) this month but switch next Sep (column 8), I know that i can nest these two functions but it is not working properly. Can anyone help? __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index, Match, Lookup, Vlookup or Combination? | Excel Worksheet Functions | |||
Index match combination | Excel Worksheet Functions | |||
Index / match combination | Excel Discussion (Misc queries) | |||
If, Lookup, Match or a combination of all | Excel Worksheet Functions | |||
combination of vlookup and match question | Excel Worksheet Functions |