Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have the box checked show up in a different sheet. The idea is that operations can look into this sheet and schedule the projects out . I have attempted a vlookup but i am getting the error code invalid data type". The formula i tried is =vlookup("0", check box column reference to other sheet, Project name column reference to other sheet) I have tried "1", "True" and "False" but none of these are getting me past the error code. Is vlookup the proper function to use for this or should i try something else? if vlookup will work what is the right formula to get it to work?
