Skip to main content

vLookApp - A Free vLookup Function for Monday

  • Jun 15, 2021 12:34 PM UTC
  • 58 replies
  • 17179 views

Yoggie
  • Participating Frequently

- What is your app called? - vLookApp.
- Why did you build this app? - Because I needed this tool.
- What does your app do? - Exactly what it says, a Lookup function across Monday boards.
- What example use cases and workflows does this app apply to? - If you need to lookup a value from one column in a different columns, and return a specific value from this row (just like in other spreadsheets).
- Who are you? Are you a monday partner? My name is Yogev, and I’m not sure what a Monday Partner is.
- How can users use your app? - Just install it here and follow the recipe explanation bellow.
- Are there any dependencies (eg: must have an enterprise subscription to X tool) - No.
- Does it have a cost? - No.

Here’s an explanation on how to use the recipe:

Hope you’d find it useful,
I’m here for any questions,
You can also reach me at Yogev@formrally.com

58 replies

Brante
  • New Participant
  • Jun 15, 2021 2:29 PM UTC

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


Yoggie
  • Author
  • Participating Frequently
  • Jun 15, 2021 6:29 PM UTC

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


Brante
  • New Participant
  • Jun 15, 2021 7:13 PM UTC

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


  • New Participant
  • Jun 16, 2021 12:31 PM UTC

This looks really promising, will definitely check it out!


Yoggie
  • Author
  • Participating Frequently
  • Jun 17, 2021 5:42 AM UTC

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


  • New Participant
  • Jun 18, 2021 5:30 PM UTC

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!


Yoggie
  • Author
  • Participating Frequently
  • Jun 18, 2021 5:46 PM UTC

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


  • New Participant
  • Jun 21, 2021 10:28 PM UTC

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.


Yoggie
  • Author
  • Participating Frequently
  • Jun 22, 2021 5:48 AM UTC

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.


  • New Participant
  • Jun 22, 2021 2:57 PM UTC

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.


  • Participating Frequently
  • Jun 22, 2021 10:15 PM UTC

Workaround.

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


jjay.lewin
  • New Participant
  • Aug 4, 2021 10:12 AM UTC

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


Yoggie
  • Author
  • Participating Frequently
  • Aug 4, 2021 11:49 AM UTC

Hi @jjay.lewin !

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

Hope this helps.


  • New Participant
  • Aug 19, 2021 11:54 AM UTC

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


  • New Participant
  • Aug 24, 2021 5:56 AM UTC

Hi Yoggie, it seems formulas columns are not supported ?


  • New Participant
  • Aug 24, 2021 6:01 AM UTC

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) :


Yoggie
  • Author
  • Participating Frequently
  • Aug 24, 2021 6:45 AM UTC

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.


  • New Participant
  • Sep 14, 2021 1:19 PM UTC

Hello Yoggie

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

Thanks


  • New Participant
  • Sep 20, 2021 10:52 AM UTC

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?


Yoggie
  • Author
  • Participating Frequently
  • Sep 29, 2021 5:41 AM UTC

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


Yoggie
  • Author
  • Participating Frequently
  • Sep 29, 2021 5:42 AM UTC

Hi!

Just follow this example


  • New Participant
  • Sep 29, 2021 9:45 AM UTC

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)


cfernandez
  • New Participant
  • Oct 5, 2021 11:32 AM UTC

Hi @Yoggie

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


Paolaura08
  • New Participant
  • Oct 18, 2021 6:49 PM UTC

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.

1


3

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?