### Looking Up Data from Several Tables with Different Structures On-the-Fly

Quite frequently, we need to find some data in another Excel table. The basic case is quite easy to handle using the INDEX-MATCH approach, as is the case when we have to find data based on more than one criterion. However, we were talking about looking up data in a single table all the time. What if we have several data tables? Well, if these tables have the same structure (read: same columns) then we can put all those tables into one and reference it in the INDEX and MATCH functions. But if these tables have different structures, and it’s either impossible or impractical to create a common structure? We need a solution that’s adaptive and works on-the-fly, that is, if we change the structure of some table or add/remove tables, we don’t want to modify the formulae. Let’s see how we can solve this case. … More Looking Up Data from Several Tables with Different Structures On-the-Fly