The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Rutger's avatar
Rutger
New Contributor III
1 year ago

Xlookup not working in OS-Spreadsheets

Hi, 

We have several excel sheets with XLOOKUP formula. In application-spreadsheet (v6.8 and V8.4) this is not working. Whereas it is working in MS-excel.

Is this possible in OS-spreadsheet?

Working around with match/index/vlookups etc is not a solution.

Thanks,

Rutger

Excel Add In

2 Replies

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    1 year ago

    It isn't unfortunately (not in 8.5 either). What is wrong with the workaround you mentioned? We did that for 20 (30?) years!

    I guess your only other option is to use the Excel add-in rather than the built in spreadsheet.

  • Rutger's avatar
    Rutger
    New Contributor III
    1 year ago

    we have modernized some excel sheets as users did not understand match/index , this was replaced by the 'modern' xlookup formula. It is like we moved on and left the match/index to the past :-).

    think we need to go back.