I need a formula that would list multiple occurrances if a single criteria is met. In most instances, there will be more than one. Was wondering if this something like this would work:
if F8:F38=15, and F11 happens to equal 15, then return A15...or if F20 also equals 15, return A20, etc, or if there 15 doesn't occur in in F8:F38, for it to remain blank instead of returning #N/A error message.....essentially that is all I need it to do
if F8:F38=15, and F11 happens to equal 15, then return A15...or if F20 also equals 15, return A20, etc, or if there 15 doesn't occur in in F8:F38, for it to remain blank instead of returning #N/A error message.....essentially that is all I need it to do