The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar

Create a Vlookup function

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

Tracking Number:

Defect ID:

1 Comment
Level III

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.