Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complex Lookups
Hi guys,
I´m trying to create some formulas which best can be described in the attached example; Hope someone can give ideas/crack this. Cheers, Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Lookups
Il 27/09/2012 08:46, MartinSvan ha scritto:
Hi guys, I´m trying to create some formulas which best can be described in the attached example; Hope someone can give ideas/crack this. Cheers, Martin +-------------------------------------------------------------------+ |Filename: example 2.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=606| +-------------------------------------------------------------------+ Look if that's what you want http://sharesend.com/jl0ht Hi, E. |
#3
|
|||
|
|||
Quote:
I cannot access your reply through "Sharesend". Can you send it through an attachment? Martin |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Lookups
Il 28/09/2012 14:44, MartinSvan ha scritto:
I cannot access your reply through "Sharesend". Can you send it through an attachment? Martin +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ Try this link http://www.4shared.com/office/iPaaxgbi/MartinSvan.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Lookups
On Wednesday, September 26, 2012 11:46:27 PM UTC-7, MartinSvan wrote:
Hi guys, I´m trying to create some formulas which best can be described in the attached example; Hope someone can give ideas/crack this. Cheers, Martin +-------------------------------------------------------------------+ |Filename: example 2.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=606| +-------------------------------------------------------------------+ -- MartinSvan Hi Martin, In J2, L2, O2, P2 enter Fruit, Veg, Fruit list, Veg list. O3-O8 list the fruit P3-P8 list the vegs In J3 enter =IF(OFFSET($J$2,ROW()-2,5)=0,"",OFFSET($J$2,ROW()-2,5)) and pull down. I pulled down six rows with all these formuls in this example. In L3 enter =IF(OFFSET($L$2,ROW()-2,4)=0,"",OFFSET($L$2,ROW()-2,4)) and pull down. In your Basket# chart under apples select the six rows and name that selection "apples". Do the same for all the other fruits & vegs in the chart. In K3 enter =IF(J3="","",SUM(INDIRECT(J3))) and pull down. In M3 enter =IF(L3="","",SUM(INDIRECT(L3))) and pull down. Hopefully this will get you started and you can expand the ranges as needed.. I am pondering the Table 2:Input Table to understand whats going on there.... HTH Regards, Howard |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Lookups
On Wednesday, September 26, 2012 11:46:27 PM UTC-7, MartinSvan wrote:
Hi guys, I´m trying to create some formulas which best can be described in the attached example; Hope someone can give ideas/crack this. Cheers, Martin +-------------------------------------------------------------------+ |Filename: example 2.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=606| +-------------------------------------------------------------------+ -- MartinSvan Hi Martin, For the Item= - Category= Table 2: Input Table. A2 enter "Item=" A3 enter "Category=" B2 to G2 enter the items, apples, potatoes etc. I added radish in this example. B3 enter =VLOOKUP(B2,$A$9:$B$14,2,0) and pull across to G3 A9 to A14 list all the items and in B9 to B14 enter if its a fruit or a veg.. Is that something like you wanted? Regards, Howard |
#7
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Lookups | Excel Discussion (Misc queries) |