13 May 2024 ... XLOOKUP(A1 , B1:B10 , C1:C10 , , , -1) will search for the value in A1 , within area B1:B10 and return a corresponding value from C1:C10
How do I use XLOOKUP - microsoft excel - Super User
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.