Conditional lookup using power query

[Negi1984]

Hi All,

I am importing 2 tables from a folder in master file link below:-

1) Date: Column I to AS are imported from original data and G & H I have inserted via Power Query.

2) Techno_Mapping : This is another sheet from where we need to take reference to insert new columns in Data sheet.
I am confused how to insert the new conditional columns.
New Column Headers are :

2G

3G

4G

2G Techno

3G Techno

4G Techno

<colgroup><col width="82" style="width: 62pt;"><col width="84" style="width: 63pt;"><col width="90" style="width: 68pt;"><col width="94" style="width: 71pt;" span="3"></colgroup><tbody>
</tbody>

Logic for the same :-

1) 2G column : If column H is 2G then column A should be Column G , otherwise lookup the respective site code of Column G in Techno_Mapping

2) 3G column : If column H is 3G then column B should be Column G , otherwise lookup the respective site code of Column G in Techno_Mapping

3) 4G column : If column H is 4G then column C should be Column G , otherwise lookup the respective site code of Column G in Techno_Mapping.

When All these 3 column filled then lookup the respective code Techno in Techno_Mapping and fill the column D/E/F respectively.
Can anybody suggest me how to do this conditional lookup in this case.
Below is the link of the file


https://1drv.ms/x/s!Ap80Ku6M2Tw5gTDr2T4aCNWu44O9


Regards,
Rajender