Is something like Xlookup available in calc? I am trying to retrieve data from column that is left so naturally VLOOKUP doesn’t work here.
I have used Xlookup in excel and it worked but I use LibreOffice at home and I wanted to know if LibreOffice has the Xlookup function.
Basically this is what I need
I have 2 different sheets
the first sheets has Rank, Team Name and Team Owner for columns and this is where the Data is located.
Sheet 2 has the same columns but I need to bring the data in the rank column in the first sheet over to the second one based on team name or team owner.