Hello Forum.
Would really appreciate some help please.
I require some assistance to index & match for 4 criteria. I can get the formula to work for 3 criteria - but I need the extra criteria to stipulate for Gross or Net values.
Many thanks - Have a look and see if you can crack it. I have left my attempts in so you can see what I have tried.
(note: do not want to use a pivot on this occasion). Assume index/match is the best formula for this problem.
denise
Bookmarks