Advanced VLOOKUP & HLOOKUP Setup

I need a set of fresh VLOOKUP and HLOOKUP formulas built from scratch to pull text-based values spread across several different tables—definitely more than two. The source sheets are already prepared; what’s missing is the logic that ties them together so each lookup returns the correct string every time, even when some tables have additional columns or slightly different header orders.

Your task is to craft the formulas directly in my workbook, test them with sample entries, and leave clear cell comments so I can trace the logic later. If a straight VLOOKUP or HLOOKUP proves limiting, feel free to combine them with INDEX, MATCH, or CHOOSE so the solution remains robust as the dataset grows. Once everything is wired up and passing spot checks, we’re done.