Display a value based on the date

[Philly500]

any ideas on where I would start with this?

I have two tables and I wish the level column to display the priority level based on the date automatically


Booking.jpg

[Jdevil]

Because you only posted pictures I'm not sure if this is going to work but try it, otherwise please upload a file:

=VLOOKUP(LEFT(TEXT(I2,"MMMM"),3),$F$3:$G$14,2,FALSE)

[Pepe Le Mokko]

Perhaps =INDEX($g$3$g$14,match(text(I2,"mmm"),$f$3$f$14,0)) in J22. pull down as needed

(If it doesn't work, post a sample sheet - Thx

[Jdevil]

Perhaps =INDEX($g$3$g$14,match(text(I2,"mmm"),$f$3$f$14,0)) in J22. pull down as needed

(If it doesn't work, post a sample sheet - Thx

Is the english version of text(Cell,"MMM") always giving 3 letters? In french it sometimes gives me 4 letters (such as "mars")

[Philly500]

Brilliant works exactly how I wanted it to, thank you very much