vLookApp - A Free vLookup Function for Monday

You can show an example here? I make some tests but not see what work properly, thanks

Sure thing, here’s a working example with a recipe:

Perfect, thanks for the help.
This help me a lot

This looks really promising, will definitely check it out!

Thank you!
Let me know if you need any help.

Howdy! Just installed this, but am having trouble accessing it within the automations view. Is there a certain set of steps I need to take to find the vlookup functionality? Thanks!

Hi @jared.smith !
It’s under “Integration” not “Automation”

Hi @Yoggie
I’m not sure if I’m doing it right:

Look up a value in client SKU in Artwork, column (Name), Return value from Status and mirror it to Approval

Artwork is the board where my client is a guest and confirms via a status column when each tag is approved or under review. I want that response to show up in a board where my colleagues are (Approval column) so they can see as soon as the same tag is approved within that second board.
The column Name is the first column from the left, I don’t see any other way to reference it. Nothing is showing up.

Hi @Paolaura !

Unfortunately, what you refer to as “the first column from the left” in not actually a column, it’s the Item Name, this is how Monday boards are designed, unlike in an excel spreadsheet.
Notice that you cannot move or delete it, for the exact same reason.

You can use this app with any other regular column though.
Hope this helps.

Thank you, @Yoggie!

If I were to move it to the second column rather than trying to use the first, what would I need to correct?
I think I am interpreting the recipe wrong.

Workaround.

You can use a formula column to have h to e item name duplicated into it and link that.

Hey @Yoggie I love the app! However, is there a way to have the “column” that contains the value I want to look up/look for to be the Item’s name?

same for the target I am looking it up in? Like, I want to use it for a central database of clients, so when I make a new board for a specific event that some clients might be interested in then I can just copy in their names and it instantly mirrors in all the relevant contact details.

Regards,
Jake

Hi @jjay.lewin !

Just use a formula column and mirror the item’s name:

Hope this helps.

Hey Yoggie. Thanks for helping me set this up! Very useful app 😬

Hi Yoggie, it seems formulas columns are not supported ?

I’m trying to have Vlookup replace the mirrors columns of monday, I though I could use the link board column and then use Vlookup to update the status of my columns (instead of having mirrors columns). However I see that the linkboard column is also not supported (VL1 in my screenshot) :

Hi @EA8 !

Unfortunately Monday don’t store the value of a formula, so automations and integrations do not apply to it.
They might change it in the future, the app is set to be able to handle function columns once they do.

Hello Yoggie

Will you able to share the source code of this integration? Or maybe an example or template?

Thanks

Hi @Yoggie,

I’ve been trying out a few tests and it doesn’t seem to be working for me. When I try to select the Status and Target Status I get a dropdown that allows me to input a text rather than selecting the specific columns. Should I input the name of the column or the column number?

I’m having the same problem here, @Yoggie could you help us please?

Hi!
Just the name, it’s case sensitive so it should be exact.

Hi!

Just follow this example

Hi @Yoggie ,

1. Do the target column and column holding the value have to be the same format?

2. Can this work by checking values in Dropdown column and mirroring it to a Status column? (It works the other way around like in your example from status to text, but can’t seem to mirror values into a status column)

Hi @Yoggie

Great app!! Do you have a server to run it? What platform are you using?
Thanks!!

Hi @Yoggie

I’ve applied the recipe for the integration this way:

Look up a value in Doctor Name in New Client Onboarding, Dr.Name, return value from call date and mirror it to Launch Call Date.

I want the date registered for a specific Dr in the New Client board to be mirrored in the Master client board. I used the recipe example that you posted above in response to Brante. Can you confirm if I’m doing something wrong, please?