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...
=INDEX($B$1:$F$1,MATCH(1,($B$3:$F$3<=E8)*($B$4:$F$4>=E8),0))
This formula works in my sample file. 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 2021.
In cell H12 there isn't a value so far because cell F4 is empty. If you enter e.g. 500 in cell F4 then "$70" is returned in cell H12.
Thank you, it works perfectly!
