I want two use the following columns in a source and target table to locate a third column in the target table
Source Table(same field exist in target table)
source column field(same field exist in target table)
source xml folder (only found in target table)
I have the following statement but it is only using the source and target column field to find the matching field
Is there a way to use both table and field columns to find the appropriate Xml folder column?
=index('[SourceToTargetMapping_PRCL.xls]Source to Target Mapping'!$H$4:$H$879,MATCH(H4:H19,'[SourceToTargetMapping_PRCL.xls]Source to Target Mapping '!$J$4:$J$879,0))
Bookmarks