I have a pretty simple thing (or so i would think) that I would like to
acheieve.

I am making a spreadsheet for people who work multiple jobs, I have a drop
down of the different locations, that information is on a different worksheet
and grouped as "venues" the column adjacent to the venues column is a pay
group (that at this point is not grouped)

What I want to happen is you choose a "venue" in cell C1 and it will
populate hourly rate in cell E1 It seems pretty straight forward, but I just
can't seem to find the answer in help. The main reason I don't just do a
straight if then or vlookup is I want to be able to protect the sheets so I
don't lose my formulas, but you could still add new "venues" with
corresponding pay rates.