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?

[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.

[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.