New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
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?
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.