In Excel, data is arranged in columns; in Access it is in rows. Row data is compartmentalized (tables) and relationships are designed so that table data can be grouped as required. If Access is a hammer, Excel is a screwdriver and you should not design as if they were the same. If you do, you will only struggle in Access most of the time. There really is no equivalent to V or H lookups in Access (at least not to my mind) because you shouldn't need them if your db is properly normalized. You might benefit from researching db normalization to see if you got off on the wrong foot.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.