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 ...
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.