Forum Discussion
Complex IF Formula with multiple
Hi, I am new to Excel and trying to complete what I would consider quite a complicated IF formula (if that is even the correct function to use here!) An example of my Dataset: A B C D ...
At least couple of variants
1)
=LOOKUP(2,1/($J$2:$J$7=$B4)/($K$2:$K$7=$D4)*$L$2:$L$7)2)
=INDEX($L$2:$L$7,MATCH(1,INDEX(($J$2:$J$7=$B4)*($K$2:$K$7=$D4),0),0))
Thanks for the quick reply SergeiBaklan
Quick question, of the 2 options you've provided, which would be more suitable if the rates were changing quarterly? Also, in my example the cat/dog/fish were the same in both funds, what if there are different types for each fund? E.g. fund 1 = cat, dog fish however fund 1 = owl, cow, horse
would there be a more favourable formula of the 2 options you've provided?
Better the formula with which you are more familiar, I personally prefer INDEX/MATCH.
Your lookup the combination of fund and type, i.e. (FUND=fund1) AND (TYPE=type1), that doesn't matter which exactly types are.