• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup formula not working for the attached spreadsheet


New Member
Can anyone give me a solution why vlookup formula is not working for the attached file.
I need to set quarter against dates.
Quarter table is also attached.
The dates in the Test Date column are not true dates, only text that looks like dates.
Convert them to real dates, then test the formula:
=VLOOKUP([@[Test Date]],Table_1,3)
See attached (removed rows 25000 and above to reduce file size).


  • Chandoo56924formula Vlookup not working.xlsb
    993 KB · Views: 5