Forum Discussion
Countrows Function with subsequent cell/Row value part of the criteria
Solution SageI'm not sure what you're trying to do here, is there another criteria that you're wanting to add on if something matches year 1/engineer callout/job complete?
I'm also not sure why you're using the filter function as part of that expression?
Thanks for replying jtomson,
Yes i am trying to add another function as part of the lookup criteria, all the other criteria i have in the expression are using a text based lookup, i.e. count the amount of rows where the text "Yr 01" appears in a certain column, that works fine.
What i want to add as part of the lookup formula is if whatever appears in one row of a column of data of the first table, matches whatever appears in another another row of a column in my second to table. So it adds to part of the lookup criteria
Regards
Dan