Hello!!

I have column B that has data validation in very cell. Users can choose an item from that list. When they choose a text item, I would like a specific number to display in Column D. All text items will have a number assigned to them and I'd like to automatically display in the column (same row). I have set up a table on the same sheet as follows:

SW Mid 12
SW Night 10
RN Night 10
RN Early 7.5
RN Mid 7.5
RN Late 7.5
SW Early 6
SW Late 6



When I use function =VLOOKUP(B2,Y243:Z250,2) on row 2 (or any of them) - it's not working. Some cells have worked but most of them say N/A or it's not displaying the correct number.
Also - is there a way of writing the function so that if the item on Column B ever gets changed the number in Column D will automatically update?


Heeeellllppppp

Thank you in advance.