Apple Numbers Question

So I have been trying to search ALL over the internet, reddit, and others to see if this is something I can accomplish in Apple Numbers. I was spitballing with ChatGPT in order to see if there was something I was missing, but any solutions in offered that totally seemed like the thing to used didn't work (LOOKUP, VLOOKUP, even INDEX/MATCH) I had ChatGPT explain what it is that I am trying to do so that any folks looking to help don't need to sort through my ramblings.

"You want to automatically update the "Level" column in your main sheet based on the "Total XP" values. The levels should be determined by a reference table that maps XP values to levels. When a "Total XP" value falls within a certain range specified in the reference table, the corresponding "Level" should be updated to reflect that range.

Key Components:

1. Main Sheet: Contains categories, Total XP values, and a Level column that needs to be updated based on Total XP.
2. Reference Table: Contains XP thresholds and their corresponding Levels. This table defines what XP range corresponds to which Level.

Desired Outcome:

When the Total XP value in the main sheet changes, the Level column should automatically reflect the correct Level according to the XP thresholds defined in the reference table.

Example:

• If the Total XP for "Cooking" is 20, and the reference table defines that 0-82 XP corresponds to Level 1, the Level for "Cooking" should be 1.
• If the Total XP for "Financial" is 94, and the reference table defines that 83-173 XP corresponds to Level 2, the Level for "Financial" should be 2.

Your goal is to use a formula or function in Apple Numbers to dynamically update the Level column based on the Total XP values and the reference table." -ChatGPT

Mahalo for any help offered!