Forum Discussion
Solved
Issue with long nested IF formula (alternative way?)
Hi, I seem to have an issue with a long IF formula I am trying to build. The formula itself works, but I think there could be a quicker and more clever way to achieve the same outcome. I'd like y...
Luca_Morrone91 This is typically something that you can handle with INDEX and MATCH. See attached. Have used some named ranges to avoid long/and absolute references in the formula. And by the way, I changed the headers on row 1 to numbers 1 through 26 in stead of 1st, 2nd, 3rd etc.
=INDEX(Quantities,MATCH(A16,ProdDescr,0),MATCH($B$13,NbrOfOrders,0))-INDEX(Quantities,MATCH(A16,ProdDescr,0),MATCH($B$9,NbrOfOrders,0))
Luca_Morrone91 This is typically something that you can handle with INDEX and MATCH. See attached. Have used some named ranges to avoid long/and absolute references in the formula. And by the way, I changed the headers on row 1 to numbers 1 through 26 in stead of 1st, 2nd, 3rd etc.
=INDEX(Quantities,MATCH(A16,ProdDescr,0),MATCH($B$13,NbrOfOrders,0))-INDEX(Quantities,MATCH(A16,ProdDescr,0),MATCH($B$9,NbrOfOrders,0))
wow, thanks Riny, that was quick. Truly appreciate your help 🙂