Forum Discussion

littlesmith2's avatar
littlesmith2
Copper Contributor
Jan 06, 2020
Solved

Help with LOOKUP

Hello,   I am working on a project that is pulling rate data from a select range of dates from company software. I have set up conversions for formatting purposes, but two of the columns for codes ...
  • Detlef_Lewin's avatar
    Jan 06, 2020

    littlesmith2 

    With a different setup it maybe would be easier to comprehend.

     

    The problem goes back to sheet VSRs.

    As of row 52 the start dates in column F and column N are not the same as in column B.

    And column B is used in sheet Date Conversion for all start dates in the different categories.