Forum Discussion
Nested Xlookup Function
Hi, Please can someone help me amend my formula to include the type to be IN/OUT. E.g. Factor = Loss, Client = Andrew, Type = OUT would return -2 as my current formula: =XLOOKUP(K4,B3:B5,XLOOKU...
=INDEX($D$4:$G$5, MATCH(K4, $B$4:$B$5, 0), MATCH(1, ($D$2:$G$2=J4)*($D$3:$G$3=I4), 0))
thank you for this Hans - very helpful
