Forum Discussion
Display Last Value in Column when certain criteria match
Hello all, I am trying to find a way of displaying the last value in a column when certain criteria match... Criteria that need to match would be Design, Colour and Size, so the quantity column...
=INDEX($D$4:$K$50,LARGE(IF(INDEX($D$4:$K$50,,
MATCH(TRUE,$D$1:$K$1&$D$2:$K$2&$D$3:$K$3=O2&P2&Q2,0))<>"",ROW($D$4:$D$50)-3),1),
MATCH(TRUE,$D$1:$K$1&$D$2:$K$2&$D$3:$K$3=O2&P2&Q2,0))This formula works in my sample file and in modern and legacy Excel. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2024. The formula is in cell R2 and filled down.