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 OBVI and ONEX are reporting errors and I'm not sure why. If anyone can solve this mystery, I'd greatly appreciate your help. 

(See C88 and E88 on the Conversion tab)

 

-littlesmith2

  • 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.

     

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    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.