• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

In Excel 2007, how should I change my formula so I don't get a #VALUE error?

I have this formula now in O27:


The value in column 13 (referred to in the formula) is a customized date value in the format YYYYMMDD (localized: ÅÅÅÅMMDD), which I however need to enter as, for example, "2016-11-27" whereupon Excel automatically converts it to "20161127" in O27.

But I get a #VALUE error for above VLOOKUP formula for some reason.
  • 2
1 Solution
Roy CoxGroup Finance ManagerCommented:

hermesalphaAuthor Commented:
Thanks, now the #VALUE error disappeared.
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now