conditional formatting with lookup

[DDT123]

Needing a little help please. I'm needing conditional the formula for Column C to add text after doing a lookup of the value in Column B and the corresponding values in Column F. Please see the screenshot for an example. The data and conditioning were manually entered to show what the output should look like.

Thank you in advance for your help.

 

[GuzmanServices]

Please try the following Conditional Formula on Cell C5 and Copy down as needed:

=IF($B5>=$F$8,$E$8,IF($B5>=$F$7,$E$7,IF($B5>=$F$6,$E$6,IF($B5>=$F$5,$E$5,""))))

 

[DDT123]

Please try the following Conditional Formula on Cell C5 and Copy down as needed:

=IF($B5>=$F$8,$E$8,IF($B5>=$F$7,$E$7,IF($B5>=$F$6,$E$6,IF($B5>=$F$5,$E$5,""))))

Awesome! Thank you that worked!!