I looked at the vlookup function and I am not sure how to set it up for these
conditions.

I am also trying the lookup function but I can't create the right condition!

=LOOKUP(C18<,C1:C4,B1:B4)

c18 = 3500

C D
1500 PHD1
2500 PHD2
3500 PHD3
4500 PHD4