Forum Discussion
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
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_LewinSilver Contributor
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.
- littlesmith2Copper Contributor
Thank you very much Detlef_Lewin - I overlooked this issue. I appreciate you digging into it!