Excel - Help on VLOOKUP Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to say if the value that returns from the v-lookup is 00/01/1900 leave blank, this part I have done, but then I want it to say if there is a real date to put that. That's where I'm stuck. So far I have the following: =IF(VLOOKUP(RC[-8],[MLS_Board_2018.xlsx]Domestic!C1:C16,16,0),00/01/1900,"") Please can you help? Thank you.
Solved by S. D. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/07/2018 - 03:21
Welcome to excelchat.
User 06/07/2018 - 03:21
Hi Zac, thank you.
Excelchat Expert 06/07/2018 - 03:21
My understanding is that you need help with a VLOOKUP, right?
User 06/07/2018 - 03:21
yes please.
Excelchat Expert 06/07/2018 - 03:21
Well, can you show me the file you are working with?
User 06/07/2018 - 03:22
Are you able to see the formula I've put in?
Excelchat Expert 06/07/2018 - 03:22
Yeah, I can see the formula.
User 06/07/2018 - 03:22
I can't share documents with you as they are work documents.
Excelchat Expert 06/07/2018 - 03:23
I understand.
User 06/07/2018 - 03:23
The result I'm trying to get to is to show me a real date or just blank if it's 00/01/1900, I have this, but the real dates are not showing their value correctly.
Excelchat Expert 06/07/2018 - 03:24
Although you can share the files with dummy data on it, right?
User 06/07/2018 - 03:24
Hmmm I'm not sure. I'll try.
User 06/07/2018 - 03:24
But are you able to advise how to get the date to show correctly?
Excelchat Expert 06/07/2018 - 03:25
Thank you, I'll be also working with something in the meantime to see whether I can get it to work without the file.
Excelchat Expert 06/07/2018 - 03:25
Yeah, I believe I'm.
Excelchat Expert 06/07/2018 - 03:27
I believe I have figured it out, So I no longer need to see the file.
Excelchat Expert 06/07/2018 - 03:27
I'll share the solution shortly.
Excelchat Expert 06/07/2018 - 03:28
Please try this formula =IF(VLOOKUP(RC[-8],[MLS_Board_2018.xlsx]Domestic!C1:C16,16,0)="","",VLOOKUP(RC[-8],[MLS_Board_2018.xlsx]Domestic!C1:C16,16,0))
User 06/07/2018 - 03:29
I nearly had the dummy data for you, but you beat me to it :)
User 06/07/2018 - 03:29
It works perfectly! Thank you :)
Excelchat Expert 06/07/2018 - 03:30
:)
User 06/07/2018 - 03:30
Have a great day!
Excelchat Expert 06/07/2018 - 03:30
I'm glad to hear that.
Excelchat Expert 06/07/2018 - 03:30
Please consider leaving a 5 star rating.
User 06/07/2018 - 03:30
Where do i do that? Of course I will :)
Excelchat Expert 06/07/2018 - 03:30
Thank you and you too have a great day!
Excelchat Expert 06/07/2018 - 03:30
Oh, you can rate me after closing this chat.
User 06/07/2018 - 03:31
Great, thank you.
Excelchat Expert 06/07/2018 - 03:31
Thank you.
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.