• 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.

Matching value in Vlookup to return value in column only if returning value is year 2023 (hard coded)


New Member
Hello Chandoo family,
I have the following scenario:
In Sheet2, I want to look up the order number in Sheet1, and if it finds a matching order number in Sheet1 and the start date in Sheet1 is "2023", then I want it to say "Y" otherwise blank; if there is no matching order number, I also want it to be blank.

Thank you so much in advance for your help!


  • In Construction Lookup.xlsx
    9.5 KB · Views: 8
Hi @bharath, thank you so much for your help, and your speedy response. This is just what I was looking for and it works wonderfully!

Thank you again for your help!