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.
Tried the mentioned formula but it doesn’t work well
New contributor
Edi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.