VLOOKUP/XLOOKUP like function in Databases?

[Rune Rasmussen]

Hello

I am trying to sell the idea of Confluence Databases internally as an alternative to the light quick-and-dirty spreadsheets that gets cobbled together every so often.

For us, we quite often need to fetch information from other tabs or spreadsheets so we use VLOOKUP and XLOOKUP (in Excel) quite often.

Example:
Database1 contains two columns. User Email and User ID.
Database2 contains two columns. User Email and User Office.

I want to use a lookup function to lookup the User Email in either database and get the User ID/User Office, so I end up with a database with all three columns.

Is there such a function in Confluence Databases?

[Nelson Pereira]

Hi @Rune Rasmussen 

I know it's not quite what you're looking for. But this Office Editor app allows you to embed a full spreadsheet in any Confluence page with all the Excel functions you're used too from the desktop. You can use VLOOKUP and XLOOKUP functions in full tab edit mode. The app it's free.

I don't know of any native VLOOKUP and XLOOKUP functions on Confluence Databases.

Hope it helps. 

[Rune Rasmussen]

Thanks.
Though then we may as well just use Excel. It'll just be adding an extra step while achieving the same result.

[Stiltsoft support]

Hi @Rune Rasmussen ,

We can suggest trying the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

You may use the Table Spreadsheet macro and work with Excel-like formulas right in Confluence without switching to other products.

Or you may keep your data in regular manually created Confluence tables and look up them using the Table Transformer macro (the source tables can be grabbed from other pages as well, they are not strictly required to be placed on the same page - you just reuse them via the Table Excerpt/Table Excerpt Include macros).

If you are not familiar with the app, please book a call with the team - we'll be happy to show the use case live.

[Matthias Gaiser _K15t_]

Hey @Rune Rasmussen

have a look at the documentation about the "Entry" fields. It looks like you want to use an Entry Details field which can show values from other databases.

Cheers,
Matthias.

[Rune Rasmussen]

I did have a try with that, but it didn't quite seem to do what we need.
I couldn't find an option to say "look for value from ColumnA RowB in DatabaseC ColumnD RowE and return the value of DatabaseC ColumnF RowE.

I couldn't get it to automatically lookup and populate fields.

Does that make sense?

[Matthias Gaiser _K15t_]

Ah, you're right @Rune Rasmussen

It doesn't really work the way you described. You can achieve the lookup of values like this. Let's assume, you have two tables ID Table and Office Table:

Then you can configure an aggregated table which looks like this:

The drawback here is that every table from which you want to look up values needs an entry link field so that Databases now which rows are related. It doesn't support the dynamic lookup via a field value.

I think, that's the best you can get so far.

[Carla Ann K_ Rowland]

Q: do you have a jira instance or just confluence. Are these users part of your confluence database?

[Rune Rasmussen]

We have both Jira (SWM and JSW) and Confluence.
In my example the users would be part of the Confluence database, but the use case I'm looking to resolve could be any kind of data where you would want to lookup data from another database, and then auto-populate a column based on the lookup, like you can do with VLOOKUP or XLOOKUP in Excel.