Hi,
I wanted to use an index function combined with 2 match functions,
whereas both of the match functions refer to different rows.
I want to avoid using a help row where I concatenate both column criteria and also want to avoid using an array function as this consumes CPU.
In column CQ (YELLOW coloured cells only) you see my attempt to nest an "and" function to look up both column criteria without using an array formula or concatenating both column criteria.
For example I want to display in cell CQ7 the value which can be found in CY 1 (columns As to AV) and there matches the criterion "LowerBand1".
Apparently I am always getting the value from column AS
Many thanks in advance
Philip
Bookmarks