1. XLOOKUP
Use the XLOOKUP function to find things in a table or range by row.
This is an upgrade compare to VLOOKUP.
I'm looking for revenue of a given product for multiple years. Unlike VLOOKUP, adding a column won't break the formula.
The formula: =XLOOKUP(A11,A2:A8,B2:H8)
Lock down made it possible for people to regroup, connect with God and Ancestors.
In that process it exposed alot of people within their circle, that so and so akekho right mos. Others even started dreaming about the people that were dear to them bevezwa ba akekho right.