XLOOKUP substitution in Excel 2019 (ofline)

[kptmarciano]

Hello,

I've been using XLOOKUP function in Excel 365 online and I'd like to use similar functionality offline too (not possible with XLOOKUP function as far as I know)

Sample worksheet in attachment.

Goal is relatively simple, but I've been trying with different formulas and it turned out that it won't be that simple as I thought it'll be (I'm not that much skilled in Excel though)

What I want to do:

- Based on data in column A in a "Product list" tab
- Pull values from "Data" tab and enter them in columns F and G in "Product list" tab

Any ideas how to do it in offline version of Excel ?

Thanks in advance for any help & have nice weekend

[Limor_OP]

what do you mean offline?
You dont have to be connected to the internet in order to use excel...

[kptmarciano]

what do you mean offline?
You dont have to be connected to the internet in order to use excel...

I'm sorry, by offline, I've meant in desktop app.

[CARACALLA]

Product list

F2=IFERROR(INDEX(Data!E$2:E$4,MATCH('Product list'!$A2,Data!$A$2:$A$4,0)),"")

Copy across and down

[kptmarciano]

prstscrn.png

Thank you for advice, tried this formula, but returns an error... Any idea what might went wrong ? Using Excel 2019 Desktop app.

[AliGW]

Change all commas to semi-colons for your European locale:

=IFERROR(INDEX(Data!E$2:E$4;MATCH('Product list'!$A2;Data!$A$2:$A$4;0));"")

[kptmarciano]

Oh, I've forgot about this one, many thanks AliGW for clarification, it's working :-)

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.