lookup compare

  1. W

    Conditional Formatting comparing of cells based on comparing value of one cell to a table

    I have searched for this. I have tried to retrofit other conditional formatting threads. I thought I was close but couldn't get it to function. I figure this is easy and I am just on brain melt. I am trying to make a dynamic shift calendar and when someone changes the operator who is on...
  2. A

    Calc period no using calendar tavle

    I have a calendar table with the following columns Date. . calperiod commperiodnumber 15/3/2018. 3. 3 30/3/2018. 3 4 This is linked to a transaction table on date=transdate with following columns Transdate postdate 15/3/2018. 30//32018 30/3//2018...
    • AliBb
    • Thread
    • 30/3/2018 commperiodnumberpostdate commperiodnumbertransdate lookup compare periodno
    • Replies: 4
    • Forum: Power Tools

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top