|Dear DerbyDad03, |
Thanks for your response. Indeed, it works just fine if I drag the formula in rows adjacent to $J$5:$J$14.
This leads me to a couple of other questions:
1. I'm thinking that I need the range to be $J$5:$J$14 because if I leave it as simply J5:J14, when I drag the IF function, the range will be altered. Am I correct in thinking this way?
2. How can I get the IF function to return the correct results in a different location (not adjacent to me specified range), e.g., in a different sheet?
This is important for me to understand because what I'm ultimately trying to do is combine this with other functions to create a formula that will return multiple entries from a list that match today's date. (The formula I've come up is =INDEX($J$5:$O$15, SMALL(IF($R$5=$J$5:$J$14, ROW($J$5:$J$14)-MIN(ROW($J$5:$J$14))+1, ""), ROW(J4)), COLUMN(J4)) but it also returns "#value!" I suspect because I'm somehow specifying an invalid range).
Any advice you can give will be very helpful.