If/Vlookup statement help

[tglane]

I'm using the following formula to lookup data from one workbook to another. The data it's pulling is a date. What I also need to do, though, is that if the data pulls a zero, I'd like it to display the "-" character, and not a date of 1/0/1900. What else do I need to add to my formula?

=IF(C678="Yes",VLOOKUP(B678,'[Workbook File Name.xlsx]'!$D$3:$Q$6121,14,FALSE),"-")

Thanks so much!

 

[Jonmo1]

Welcome to the board..

You might just tell Excel to Not display 0's.

Tools - Options - View
UNcheck Zero Values

 

[tglane]

Thanks for the welcome!

That may fix it on my end, but what if I need to share this with someone else? If they don't have that option checked wouldn't it open up for them showing the 1/0/1900 date?

 

[Jonmo1]

No, it's a sheet level setting. Not an application level setting.
It won't even apply to all sheets, just the one active at the time you set it.

 

[Jonmo1]

I should clarify my answer...

YES, it will apply when other user's open it.
The setting is saved to the sheet, not the Excel Application.

 

[tglane]

Awesome! Thanks so much for your help. That makes life so much easier than trying to write it into the formula.