Xlookup in LibreOffice Calc

[Barman5000]

Hi everyone
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.

Thanks

[JohnSUN]

How to easy combine INDEX() and MATCH()

[schiavinatto]

Hi, @Barman5000,

=INDEX(wanted_column;MATCH(1;(criteria_column_1=valor)(criteria_column_2=valor);0))

Optional for more than 1 criterion, add as many as needed

Example of use

---

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball to the left of the answer, to finish the question.

[Busa]

Hi @schiavinatto ,
Just wanted to let you know your solution solved a long running problem that I have had regarding the VLookup function in Calc. My worksheet is a mileage and fuel recorder for a certain vehicle and the dates that fuel and mileage was recorded. However much I tried the VLOOKUP function didn’t give reliable results but your solution works perfectly.
Regards

[mariosv]

There is a request for enhancement tdf#127293 - Add XLOOKUP function in Calc

[raffaem]

It will be available in LibreOfficeDev 24.8, see the docs: XLOOKUP Function

In the meantime, there is this extension for previous versions of LibreOffice: Lox365: XLOOKUP for LibreOffice » Extensions