nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a Vlookup function

anaheilman

Support,

I found a way to create a vlookup through scripting in JSL, but is there a possibility to include something like this in the formula editor under the Comparison menu?

Thanks for your consideration to this idea.

Ana Maria Heilman-Morales

Status: Delivered

Comments

mark_anawis

Hi Ana, Have you tried "Match"? If you select the column name first and single-click on "Match", it shows you a submenu where you can automatically add the Match arguments from the data (i.e. the values in your column). Then you can add the value you want returned in each then clause.

Jeff_Perkinson

There are many ways to get the same kind of result as VLOOKUP depending on your ultimate goal:

Virtual Join links a main data table to one or more auxiliary data tables
Tables->Join will add a column of values based on matching values
The Match function will compare values to a list and return a result

There are lots of other ways, again, depending on your need.

Ryan_Gilmore

BHarris

We use the Table -> Update feature for this all the time, it's incredibly useful.