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!!!!
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!!!!