IF/Then Commodity Prices

[lmartino]

Please assist with an IF/Then statement on this spreadsheet and I'll be your best friend

Logic should be....if Column J MERC Price = Today's date, Then look at Column D "Commodity", & utilize SettlePrice Table (Column R & S), and populate price (Col R) by Commodity (RB or HO, for example) in column N > TAS Price.

Thank you!!!!

 

[lmartino]

Apologies, this was be the corrected output. Please ignore my previous snapshot. Can you please assist?

 

[Joe4]

Please don't mark the post as the solution if it is not the solution and you still have a question.

 

[lmartino]

Understood thank you @Joe4