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