2 Replies Latest reply on Feb 13, 2015 8:34 AM by Doug Staubach

    Looking for suggestion to how to replace Excel Vlookup function.

    gregdc

      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