AnsweredAssumed Answered

Looking for suggestion to how to replace Excel Vlookup function.

Question asked by gregdc on Sep 22, 2014
Latest reply on Feb 13, 2015 by Doug Staubach

Title

Looking for suggestion to how to replace Excel Vlookup function.

Post

I am converting a set of excel spreadsheets to FM13.  Several of the sheets contain column with the VLookUp function.   (ie  Vlookup(ID, ParentNameTable, 3, False) == lookup in the partent table, using ID, return the value in the Partent tables third column if there is an exact match with ID)

I am looking for suggestions for how to covert this function to FM13 to take the ID in the record, look it up in another table and return a blank if there is no exact match, or the matching ID field's value.   I have looked at Lookup function in FM13 but do not really understand it.  I have thought,also, of using an ExecuteSQL but not sure that that is the best path.

Can someone familiar with this sort of conversion give me some suggestions/examples?  Thanks  GregDC

Outcomes