VBLookup- in a cell, select text in dropdown, in same cell, displays a number-Not workin

Hello and thanks in advance!

I found a great video from 3 years ago that showed how to create a cell with a dropdown that displayed text, and then in the same cell, it displayed a number.

His lookup table started in cell A1 and in the same sheet, his dropdown started in D1. I was able to exactly replicate his stuff and it worked perfectly. Then I tried implementing in for my worksheet, but it failed. I first tried having everything in the same sheet, but it didnt work. I had my table starting in cell AA1 and my dropdown in cell H10. I updated the number for the dropdown in his VBcode and it failed. I am very confused as to what I did wrong.

Eventually I would like to have 2 VBLookup tables. I assume the VBLookup tables need to be in the starting cell A1, so I would have the tables on different sheets than the dropdown (a total of 3 sheets). but i dont know what im talking about.... just need to get it to work correctly. It doesnt seem like this is anything complex.

In the attachment:

• I want the dropdown that says "2 Emerging" in column H (the 8th column) to only display "2" (this is on sheet "Polished")
• the table is named "UX_Skill" and starts in cell A1 (this is on sheet "Sheet3")
• the code looks correct, it references UX_Skill, the correct column for the lookup table is 2 and the correct column for the dropdown is 8

VBLookup.png