Power query . Retrieve a value from other table

[DiegoB]

Hello, I nedd help for a problem that I couldn't solve.

I have a registration number in the table A 

Table A

I have to search this number in the interval on the table B and then I want to bring de date from the table B into table A.

Table B

I prefer do this in power query.

Could someone kindly help me?

[Omid_Motamedise]

It is easy in power query, just follow the below steps

1. Select table A

2. From home tab, peack Merge command, 

3. In the oppend window, in the below box select table B.

4. Select common colmin in both the table and press ok.

[DiegoB]

Thank you, i find a problem, because the value in the table A is a value between the value in the column "form entry n°" and the value "To entry n°" in the table B. And sometimes the value (table A) may be not be explicit in the table B.

[Omid_Motamedise · Accepted solution]

@DiegoB 

In this case go to Table A add a customer column and use the below formula in this column

Table.SelectRows(tableb, (x)=> [data.entrynumber]>=x[from entry n] and [data.entrynumber]<=x[To entry n])

[DiegoB]

Thank you Omid, it works fine!