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.
