Looking for suggestion to how to replace Excel Vlookup function.
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