Hi
I've been looking at tutorials but can't quite get this to work..
I have a table with data set
[TABLE="width: 997"]
<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]CompanyID[/TD]
[TD]CompanyName[/TD]
[TD]Field Name[/TD]
[TD]Control Centre Position[/TD]
[TD]Field Source[/TD]
[TD]Country Code[/TD]
[TD]Country Name[/TD]
[TD]GDS[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]ABC COMPANY[/TD]
[TD]Cost Centre[/TD]
[TD]1[/TD]
[TD]Traveller[/TD]
[TD]ZW[/TD]
[TD]Zimbabwe[/TD]
[TD]Sabre[/TD]
[/TR]
</tbody>[/TABLE]
I need to populate Field Name & Field Source based on matches between
CompanyName & Client (cellD1)
GDS & Current Tool (cellD2)
Control Centre Position & Control Centre Position REF (column a)
[TABLE="width: 748"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Client[/TD]
[TD="colspan: 2"]ABC COMPANY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Current Tool[/TD]
[TD="colspan: 2"]Sabre[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]New GDS[/TD]
[TD="colspan: 2"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]IN/OOS[/TD]
[TD="colspan: 2"] [/TD]
[/TR]
[TR]
[TD]Control Centre Position REF[/TD]
[TD]Standard Mapping 1[/TD]
[TD]Standard Mapping 2[/TD]
[TD]Field Name[/TD]
[TD]Field Source[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
If too complex I think I can live without matching the GDS tool.
Any advice gratefully received!
THANK YOU!
I've been looking at tutorials but can't quite get this to work..
I have a table with data set
[TABLE="width: 997"]
<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]CompanyID[/TD]
[TD]CompanyName[/TD]
[TD]Field Name[/TD]
[TD]Control Centre Position[/TD]
[TD]Field Source[/TD]
[TD]Country Code[/TD]
[TD]Country Name[/TD]
[TD]GDS[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]ABC COMPANY[/TD]
[TD]Cost Centre[/TD]
[TD]1[/TD]
[TD]Traveller[/TD]
[TD]ZW[/TD]
[TD]Zimbabwe[/TD]
[TD]Sabre[/TD]
[/TR]
</tbody>[/TABLE]
I need to populate Field Name & Field Source based on matches between
CompanyName & Client (cellD1)
GDS & Current Tool (cellD2)
Control Centre Position & Control Centre Position REF (column a)
[TABLE="width: 748"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Client[/TD]
[TD="colspan: 2"]ABC COMPANY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Current Tool[/TD]
[TD="colspan: 2"]Sabre[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]New GDS[/TD]
[TD="colspan: 2"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]IN/OOS[/TD]
[TD="colspan: 2"] [/TD]
[/TR]
[TR]
[TD]Control Centre Position REF[/TD]
[TD]Standard Mapping 1[/TD]
[TD]Standard Mapping 2[/TD]
[TD]Field Name[/TD]
[TD]Field Source[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
If too complex I think I can live without matching the GDS tool.
Any advice gratefully received!
THANK YOU!