Forum Discussion
IF AND Help
Hello, I need a cell to auto-populate based on a complicated formula which I cannot figure out. I think it's a nested IF/AND formula, but I don't know how to put it together. Using the tables bel...
=INDEX($B$6:$G$6,MATCH(B2,OFFSET($B$6:$G$6,MATCH(B3,$A$7:$A$14,0),0),1)+1)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.