I had some help with the origional formulae here - please see thread for sample workbook etc.
So I have the formula:
which I managed to modify for another use on another tab (on my main file, it bears no references to the sample workbook uploaded) to this:
This basically checks if any date in the column AX matches the date in B3, and pulls out those rows.
My new problem, is that I want to add in an additional 'IF' statement, so that as well as checking if the date matches in AX, I want it to check column L and see if data matches a specific text string.
I though just adding an IF(AND(... bit in would work, but it doesn't, so I'm completely stumped...
What I thought I needed:
Can someone tell me why this doesn't work, and help me achieve what I'm after?
Many thanks in advance.
x
Bookmarks