Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Nested IF
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="EZ, post: 3828147"] Thanks Luke and Bob. It worked. The issue was with my data ranges type. the data was coming from Access as 'general' data type with leading zeros. My lookup values/conditions in Excel have to be forced as text in order to keep the leading zeros, so I went ahead and changed the ranges data type from general to text, and it worked. Thanks. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Nested IF
Top