Vlookup

[Nastya]

Hello!

I have 3 tables and I need to vlookup from the 2 circle and from the 3 hours. The table3 is the first priority. So if I found hours I don't need circle. The last column "time" put not empty rows of columns "Hours" and "Circle" 

Table 1

Route	Detail	Route+Point	Hours	Circle	Time
301	D1	301D1	2		2
302	D2	302D2	3		3
303	D3	303D3		4	4
304	D4	304D4	9		9

Table 2 - Circle

Route	Circle
301	5
302	6
303	4

Table 3 - Hours

Route+Point	Hours
301D1	2
302D2	3
304D4	9

Thanks a lot !!!

[BenMoss · Accepted solution]

Well, I think you should take a look at the Join tool and how that tool works, it allows you to perform the lookups you have identified. The only complexity is the logic for finding unmatched records on your first join with table 3. You should look at the L and R output streams for the join tool to identify the records that don't match. Then you can use those to join against the table 2.

The union tool is likely to be useful in this case! Please have a try and explore the tools available, and let us know where you get stuck after you have made an attempt.

Ben