Conditional values based on Popup menu choice

Hello everybody. I saw a similar question formulated some time ago.

My question is this: is it possible with nowadays Numbers version to select an item from a popup menu in, let's say, CELL B1 containing only 3 items A) Manager B) Supervisor C) Worker and automatically place a hourly cost A) 50$ B) 30$ C) 20$ in adjacent CELL B2 - WITHOUT creating a second table and WITHOUT using VLOOKUP? - Values are just an example...

Something meaning IF B1=Manager then B2=50$, but directly inside the popup list - (or alternatively in the B2 CELL pointing to B2 popup list values)?

I saw there is a Conditional Highliting Rule inside the popup items, but I am not sure it can be used for the purpose I need.

I mean:

B1 popup list

Manager -> B2=$50

Supervisor ->B2=$30

Worker -> B2=$20

I am new in using Numbers, so I kindly ask you, if there is a formula to be inserted in B1 (or B2), to write it down exactly the way it should be put in that cell.

Thank you in advance.