V
VCTECH
Help! I am trying to create a spreadsheet that prints specific row
from another spreadsheet in the same workbook if the following criteri
are met.
1. There is an "x" in column I
2. The value in column A matches the value in column A either above o
below.
3. A particular value can be found anywhere within 3 rows above o
below in column H.
So far I've got the formula working with the first two, but can't see
to add the third criteria and get anything to work. The formula i
getting extremely long and cumbersome and I'm LOST
from another spreadsheet in the same workbook if the following criteri
are met.
1. There is an "x" in column I
2. The value in column A matches the value in column A either above o
below.
3. A particular value can be found anywhere within 3 rows above o
below in column H.
So far I've got the formula working with the first two, but can't see
to add the third criteria and get anything to work. The formula i
getting extremely long and cumbersome and I'm LOST