Excel if(Vlookup Pulling 1900

[Anonymous]

Hello 

I have having issues with excel pulling in 1/0/1900 i under that it is a 0 in a date format and no matter what i seem to do it will not take is away. i have one excel sheet with about 9 tabs. what i need to do is search on the account name("G") and look on each tab to see what the date is i am looking for and bring it back to the main using a if vlookup 

=IF(G4="week1",(VLOOKUP(J4,'week1!B:J,9,FALSE)),IF(G4="week2",(VLOOKUP(J4,week2!B:K,9,FALSE))))

[v-henryk-mstf]

Hi @Anonymous ,

As @amitchandak  said, you can post this question in the excel forum to ask the relevant engineer for help.

If you want to implement the above calculation logic in powerbi desktop, please provide the relevant test data and screenshots of the expected results, and I will answer you as soon as possible. Looking forward to your reply.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Henry

[amitchandak]

@Anonymous , I think You should post this to the excel community.