For Example: I have 3 columns. Column A ( Vehicle number), Column B ( Opening Kilometres), Column C ( closing kilometres). Similarly all rows under column A will be having different vehicle numbers. whenever I enter the vehicle number, column B value should come up with last occurrence value of the respective vehicle ie. closing kilometres in that cell. I have tried the mentioned formula (=XLOOKUP(A3,$A2:$A2,C2:C2,,,-1)) but the formula works fine only for the first row.