how to lookup data from one table to another table using range for dynamic range of values

Hey bhelou 

Actually I have two Different Table as you can see above .

Actulay I wanted to create a Visual through which,  if i select Any Header from Table 1,  i should get only those data From Table 2 where the Engine Hours is same as Start and Stop for Header A in Table 1 .

For that we are able to lookup the Header name from Table 1 to Table 2 with condition that the Engine Hours is in Between start and stop of Table 1 .

Solution shared by by amitchandak  is working almost except for those cases where we have more than 1 start and stop Engine Hours for Header with Same Base Unit .

Let me Know if you required any other Information.

Regards

Rahul Soni

amitchandak  Hey Thanks For Solution Its Working almost However IN Case where we have Same Header Attachewd to Same Base Unit Twice with Two Different Engine Hours Range , its not Doing Lookup for Example in Below Table we can see

Header A in Table 1 Attached to a Base Unit Twice  with Two Different Tenure of Engine Hours , and Now After First Filter of VIn in Second Filter out of These Two Start and Stop Hours its not taking any , means i ma not getting any lookup value for this VIn.

Can you Help with this as well ?

Thanks in Advance

Regards

Rahul

Hey amitchandak  Thanks For Solution , its Working almost however in some cases where we have Header is attached to Same base unit more than once for Example , In Below Table

Header A is Attached to a Vin two times with two Different range of Engine Hours. In this scenario Lookup is not working 

Can you Help with this also?

Regards

Rahul Soni