Forum Discussion
Formula Help IF/AND/XLOOKUP
I have tried an IF formula, and IF/AND formula, and XLOOKUP and nothing is returning the answer I need. I even tried a long way with the XLOOKUP formula. So can someone help me please. I have attache...
I like the INDEX/MATCH formulas, but thought for one of my first posts I would also provide a solution using IF/AND and also just IF. In the first example, the formula just uses B1:F2, removing the need for extra 'helper' cells. In the past I struggled with really understanding INDEX/MATCH. IF/AND is still complicated enough but just using IF seems fairly straightforward.