Forum Discussion
Return first cell in row if condition is met.
I'm not a pro in excel I'm just experimenting some formulas for a recipe organiser. Basically, I want to return the recipe name of all recipes containing one specific ingredients, just one. I've tr...
=TEXTJOIN(";",TRUE,IFERROR(INDEX(A2:A7,IF(MMULT(N(B2:E7=G2),ROW(1:4)^0)*ROW(1:6)>0,MMULT(N(B2:E7=G2),ROW(1:4)^0)*ROW(1:6),"")),""))This works in my Excel online sheet. However it's only possible to apply this formula if you work with Office365 or 2021 or Excel online.
Thanks, but it's not working on my version of excel, I will investigate with INDEX+MATCH to see if I can crack the code :)) Thanks tho
