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

I have this formula now in O27:

=VLOOKUP(C12;Travbanor!B6:M100;13;"")

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.
LVL 1
hermesalphaAsked:
Who is Participating?
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
Try

=IFERROR(VLOOKUP(C12;Travbanor!B6:M100;13;""),"")
0
 
hermesalphaAuthor Commented:
Thanks, now the #VALUE error disappeared.
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
0
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.

All Courses

From novice to tech pro — start learning today.