cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

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

3 Comments
mark_anawis
Level IV

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
Community Manager
Status changed to: Already Offered

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
Community Manager
Status changed to: Delivered