This question is about a single function (in a single cell to later extrapolate over a whole table) in Microsoft Excel.
I want to find a unique id on another page (amongst other id's in the first column) (using the VLOOKUP function, I think) and compare the values in the other columns (in the same row) to a particular value in this page.
Basically, the first page is a few (about 6, some cells blank) dates for each unique id, the ids are in the first column, each's corresponding dates are in the same row in certain other columns (3rd, 5th, 7th, etc.). The second page is the first column as id's, and the upcoming dates (over the upcoming week) along the top row. Obviously, if a unique id (row) has the column's date (in any of the specified cells adjacent to that same id in the 1st sheet) then the cell has a 1 (or true or whatever) otherwise it has a 0 (or false, etc.). Then I plan to order the columns with the nearest upcoming ids at the top.
For the second part about checking if they match the 2nd sheet's column's date, I can only think of using the COUNTIF function, but that's only useful for looking at several cells whereas having this all in a single function seems to be inputting in as a list.
Also, the second part is comparing dates and when I'm building up a function to try to get to this end function, I often find value error which I'm confused about, I've tried changing the list and the criteria to and from: text, serial numbers, dates.
This is the function I've used for a single column of dates on sheet 1:
=IF((VLOOKUP($A5,Sheet1!$A$2:$C$6,3,FALSE)=C$1),1,0)
This is the function I used to make the values found by VLOOKUP into a list to try to input it into a COUNTIF function:
=("{"&TEXTJOIN(",",TRUE,(VLOOKUP($A3,Sheet1!$A$2:$L$6,{3,5,7,9,11},FALSE)))&"}")
And this is the most recent overall attempt:
=IF(((COUNTIF((“{“&TEXTJOIN(“,”,TRUE,VLOOKUP($A3,Sheet1!$A$2:$L$6,{3,5,7,9,11},FALSE)))&“}”),B$1)>0)=TRUE),1,0)