I am using this formula
=IFERROR(INDEX(Data!$B$4:$J$23,Data!$M4,COLUMNS($D$3:G3)),"")
to extract data based on a drop down box selection, however if the data is a date it does not show in date format.
If I format cells then cells with no data show as 01/01/1900 and I need them to be blank.
Any help is gratefully received
Hello Lbelden78,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello Lbelden78 and Welcome to Excel Forum.
You have posted your query in a forum set aside for introductions. Please repost the question in the Formulas & Functions forum of this site.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks