This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"
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.