xlsxwriter - select cells by using the hlookup python

Question

I have two worksheet in excel like this , and I want to select cells by using the Hlookup with python:

data 1:

id       D1A      D2B   D3B   D4E   D3C   
A        1        2       5     7    4
D        4        6       6          5
B                 7       1          2

data 2:

D1      
D2   
D3   
D4

if I select in data2 (for example D3), I should have as results in table data1 :

id  D3B   D3C       
A    5      4       
D    6      5      
B    7      2         

Any help on this would be appreciated.

thank you.

Answer 1

等待大神答复